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.

On Dec 26, 9:48*am, PAL wrote:
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)

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

"PAL" wrote:

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.

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)

"PAL" wrote in message
...
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.

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


On Dec 26, 12:48*pm, PAL wrote:
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,"")


"PAL" wrote:

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.