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

"Mike" 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

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"
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