IF Statement to Check for Blanks

  • Thread starter Thread starter Daren
  • Start date Start date
D

Daren

Hello,

I have an address column that I want to check for blanks. When I type
=if(g2= ,"True", "False")...with the space after the equals sign signifying
the blank, I get a syntax error. How can I correct this?

Thanks.
 
hi,

I modified your formula bur should have pointed out that this works just as
well

=G2=""

Mike
 
Quote Marks Needed

The formula to check for blanks needs a set of quote marks around the "blank." Revise the formula you have slightly as follows: =if(g2="","True", "False"). Note the set of quote marks to indicate a blank are right next to each other with no space between. Also note when using True and False this way they can be entered with or without quote marks as Excel recognizes them as distinct values. So you could also write it so: =if(g2="",True,False). Lastly, in all Excel formulas, best not to put any spaces after the commas in the formulas as they are not required.
 
Ok, I'm just gonna stick with the original. As a follow up, I want to use
conditional formatting when the value is True. I think this is cell value
is equal to True and pattern is red, but it won't take. What am I doing
wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
IF AND statements 6
Dsum excluding blanks 1
If Blank 2
IF Error 4
IF Statments in Excel 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
If statements 1

Back
Top