| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Seeking an alternative to blank ("") cell in IF arguments
I usually find it convenient to use "" in formulas such as the following:
=IF(B120,B12/C4,"") The problem of course is that an error will be returned if the cell left blank with "" is used in subsequent calculations. Is there an alternative to using zero instead of "" that still makes it obvious that the cell is intentionally left unpopulated but that does not result in #VALUE# errors? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent blank cell | Excel Discussion (Misc queries) | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| I want to select the first blank cell in column A | Excel Worksheet Functions | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Threaded Mode
