Represent blanks in an Excel IF statement?

J

JG

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.
 
R

Roger Govier

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.
 
S

Sheila D

It looks like you have a space between the speech marks which means that it
will be looking for a space, try it as "" - just the speech marks.
HTH Sheila
 
Top