| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement error check | Excel Worksheet Functions | |||
| Need Check for Blanks formula, please | Excel Worksheet Functions | |||
| Represent blanks in an Excel IF statement? | Excel Discussion (Misc queries) | |||
| Blanks as a condition of a statement | New Users to Excel | |||
| How do I check formatting in an if-then statement | Excel Worksheet Functions | |||
Linear Mode
