Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
when writing if statements, if I want a certain action when the cell is empty
i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
"mattguerilla" wrote in message
... when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. =if(A1="","do something else","do this") or =IF(ISBLANK(A1),"do something else","do this") -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
Try...
=IF(A1<"","Do This","Do Something Else") Hope this helps! In article , mattguerilla wrote: when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
IF(A1<"","do this","do something else")
"mattguerilla" skrev: when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
=IF(A1<"","Not empty","Empty")
"mattguerilla" wrote in message ... when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
=If(A1<"","do this","do that")
< means "Is not"/"Not equal to" so <"" means "is not empty" BUT equally =if(A1="","do this","do something else") would also work as the "do something else" is actioned if A1 is not empty. HTH "mattguerilla" wrote: when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement where cell is not empty
Mattguella,
This works for a cell that is empty: Cell A1 - blank, cell A2 - =IF(A1="", "got it!", "Aint got it!") This works for a cell that is not empty: Cell A2 - blank, cell B2 - =IF(A2="", "Aint got it!","Got it!") Good luck, "mattguerilla" wrote: when writing if statements, if I want a certain action when the cell is empty i write - if(A1="","do this","do something else"). But if I want it to do something when there is anything in the cell in question how do I write the statement? ie, if(A1="anything","do this","do something else". Hope I am making sense. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Refering to an empty cell | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |