| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Hi all,
Is there a 'IF' statement describing ..... IF 'a cell is empty' THEN ...... Many thx, Don- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement
Don
In any cell enter =IF(E10="","no value",E10) Note: there could be a formula in E10 that returns "" if a condition is not met, so E10 is not really empty but it will return as True. e.g. In E10 is =IF(A1=123,"OK","") Gord Dibben MS Excel MVP On Wed, 8 Nov 2006 15:23:01 -0800, Don wrote: Hi all, Is there a 'IF' statement describing ..... IF 'a cell is empty' THEN ...... Many thx, Don- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Hybrid Mode
