| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell until after formula applied
"junkmandan" wrote in message ... How can I insert a simple sum formula without a "0" appearing in the cell until the formula has been applied. Thanks By the way, in my example and Chuck's the formulae translate easily into words: =IF($A14=0,"",$A14*G14) If A14 is zero THEN put nothing in this cell (quotation marks with nothing between them). ELSE (A14 isn't blank) Multiply A14 by G14 You don't have to leave the cell empty - you could also put some sort of text between the quotes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula: " If this cell is blank, then 0" | Excel Worksheet Functions | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
