make cells with IF statement return blank cells

[Marcotte206]

This may be really obvious and I am just missing it, but does anyone know how to make an IF statement return an empty cell rather than 0?

I would like a 1 if true and [null] if false.

If this is not easily done, is there any way to even copy over or do a find/replace on the cells to get the desired outcome? Thanks.

 

[Richard Schollar]

Hi

use the structure:

=IF(YourCondition,1,"")

Note that this returns an empty string (ie "").