What does " " turn the cell?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

Say you have something like this in cell b2: If(a2=5,1," ")

If a2=3, by executing the condition above what does " " make b2?
Blank, Logical, 0, or what? If you want to refer later on to cell b2
you need to know what " " mean, right?

Thanks,
Mike
 
Hi Mike
Your formula goes this way: If A2= 5 put 1 otherwise put nothing.
Your formula is putting a blank space, there should't be any space between the
double quotation marks.
e.g. =If(a2=5,1,"")
HTH
John
 
It makes it Text; a String in vba; a Space in the vernacular.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30+ ways to sort)

..
..
..

"Mike" <[email protected]>
wrote in message
Hi,

Say you have something like this in cell b2: If(a2=5,1," ")

If a2=3, by executing the condition above what does " " make b2?
Blank, Logical, 0, or what? If you want to refer later on to cell b2
you need to know what " " mean, right?

Thanks,
Mike
 
Back
Top