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