View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.