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.

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.

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

"JG" wrote:

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.

Almost the

No space between the pair of double quotes.
--
Gary's Student


"JG" wrote:

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.