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?

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?

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?