IF Statement to Check for Blanks
 

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.

IF Statement to Check for Blanks
 

Maybe

=IF(G2="","True", "False")

Mike

"Daren" wrote:

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.

IF Statement to Check for Blanks
 

Yes! That worked. Thanks!!!

"Mike H" wrote:

Maybe

=IF(G2="","True", "False")

Mike

"Daren" wrote:

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.

IF Statement to Check for Blanks
 

hi,

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

=G2=""

Mike

"Mike H" wrote:

Maybe

=IF(G2="","True", "False")

Mike

"Daren" wrote:

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.

IF Statement to Check for Blanks
 

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?

"Mike H" wrote:

hi,

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

=G2=""

Mike

"Mike H" wrote:

Maybe

=IF(G2="","True", "False")

Mike

"Daren" wrote:

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.

IF Statement to Check for Blanks
 

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.
--
David Biddulph

"Daren" wrote in message
...
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?

"Mike H" wrote:

hi,

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

=G2=""

Mike

"Mike H" wrote:

Maybe

=IF(G2="","True", "False")

Mike

"Daren" wrote:

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.