Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing a cell
How can you clear a cell in a formula? I want something similar to:
IF(<SomeCondition,"Text","") But if I use that, and then try to count non-blank cells, the cells where "" was stored are not considered blank. How can I actually make the cell blank in that formula? Thanks. Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing a cell based on the value of another cell (INDIRECT data) without macros | About this forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Clearing a cell | Excel Discussion (Misc queries) | |||
clearing a cell | Excel Discussion (Misc queries) | |||
Clearing a cell | Excel Discussion (Misc queries) |