Represent blanks in an Excel IF statement?
 

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.

Represent blanks in an Excel IF statement?
 

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.

Represent blanks in an Excel IF statement?
 

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.

Represent blanks in an Excel IF statement?
 

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.