Alowing for the Absence of Data from Multiple cells?

  • Thread starter Thread starter Juan
  • Start date Start date
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
 
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)
 
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)
 
Well here is one of the formulae that is coming up with that annoyin
display (#/DIV0!):

=PMT(B9/12,B13,-B7)

It obviously depends on data from cells B9, B13 & B7.

I'm still trying to figure out a formula that I can put write into
cell and avoid VBA if I can. Thanks for the help
 
I put that formula in a cell and then put test data in B9, b13 and b7.

Then cleared the contents one cell at a time.

When I cleared b13, I got the divide error.

=if(b13=0,"",pmt(b9,12,b13,-b7))
 
Back
Top