| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Putting Zero in Formulas until First Figures Filled In
I have rows with formulas. No figures are put in the spread sheet yet but the
cells with formulas are reading "$0". How can I get the cell to be completely blank (except for the formula, of course) until the figures are inserted? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Putting Zero in Formulas until First Figures Filled In
=IF(OR(A1="",(B1="")),"",A1+B1)
Those are the basics to prevent a zero from showing up. Your formulas will have to be adjusted, of course. Gord Dibben MS Excel MVP On Thu, 15 Feb 2007 09:57:31 -0800, oceanmist wrote: I have rows with formulas. No figures are put in the spread sheet yet but the cells with formulas are reading "$0". How can I get the cell to be completely blank (except for the formula, of course) until the figures are inserted? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Putting Zero in Formulas until First Figures Filled In
If your formula is currently =2*A1, and you want the answer blank while A1
is blank, then use =IF(A1="","",2*A1) -- David Biddulph "oceanmist" wrote in message ... I have rows with formulas. No figures are put in the spread sheet yet but the cells with formulas are reading "$0". How can I get the cell to be completely blank (except for the formula, of course) until the figures are inserted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove figures from a cell without removing the formulas | Excel Worksheet Functions | |||
| Excel 2003 figures to words | Excel Discussion (Misc queries) | |||
| Excel 2003 sum figures without formula | Excel Worksheet Functions | |||
| Formulas do not multiply when filled down | Excel Worksheet Functions | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Hybrid Mode
