IF Statement to Check for Blanks

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

Mike H

hi,

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

=G2=""

Mike
 
D

Daren

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?
 
D

David Biddulph

You're probably getting confused between a text string "True" and a Boolean
value True. Remember that putting quote marks around something makes it a
text string.
 

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
Copy text into blank rows 2
Anything will help 0
Need help modifying code 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Check if there is a space in a string as test for IF 1
Publisher is filling blank lines with data 2
Cannot create hyperlinks - browsed internet pages do not appear in dialogue box 6

Top