#DIV/0!

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

I have a table that is performing a lot of calculations. Because there is no
data yet to complete the formula I get the "#DIV/0!" error. Is there a way
to hide this until there is a data.
 
I have a table that is performing a lot of calculations.  Because there is no
data yet to complete the formula I get the "#DIV/0!" error.  Is there a way
to hide this until there is a data.

=if(A1="", "", B1/A1)
 
Here are a couple options....

For values in A1 and B1

C1: =IF(B1=0,0,A1/B1)
or
C1: =IF(B1=0,"n/a",A1/B1)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
How about

=IF(ISBLANK(first cell),"",your_formula)

ex:

=IF(ISBLANK(A1),"",B1/A1)

This would having Excel perform your calculations twice (if the cell
isn't blank).

HTH,
JP
 
Back
Top