| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show 0.00 if referenced cell is empty
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
| How are empty cells referenced in Excel in IF statements? | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Need cells to show as zero or empty | Excel Worksheet Functions | |||
Threaded Mode
