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