Alowing for the Absence of Data from Multiple cells?

J

Juan

In my spreadsheet, I have those annoying #/DIV0! errors show up until
enter data in the supplying precedents. I found a great tip but i
only described a solution when there was one cell providing input t
the calculating cell. I have cells that depend on 7 or more predents.
Any help is appreciated
 
B

Bob Phillips

Juan,

You could try

=IF(ISERROR(my_formula),"",my_formula)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
it would be helpful if you can provide the formula you currently use.
To give you a general idea: you may use
=IF(Divisor_formula=0,"",Values/Divisor_formula)
 
Top