#DIV/0!

[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.

 

[joeu2004]

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)

 

[bj]

=if(iserror(your formula),"",your formula)

 

[Ron Coderre]

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)

 

[JP]

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

 

[Teethless mama]

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