Hi

You shouldn't include any spaces between the sets of double quotes
=IF(K2="",1,0)

Including a space is telling Excel to compare whether there is a space
in the cell, not a null value.

--
Regards

Roger Govier


"JG" wrote in message
...
How do you represent blanks in an Excel IF statement? I tried
=if(K2="
",1,0) but the " " did not work. Thank you for your time and
assistance in
advance.