You could use something like this:

=IF(ISERROR(formula),"",formula)

This will evaluate your formula, then, if an error is returned, it displays
a blank, otherwise, the results of the formula are displayed.

HTH,
Elkar


"sunderland27" wrote:

how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?