In the unlikely event that D2 is less than 1 after data has been entered, maybe

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

"Peo Sjoblom" wrote:

If you use

=C2/D2

then you can change it to

=C2/MAX(D2,1)


Regards,

Peo Sjoblom


"Mike800W" wrote in message
...
How do I change the way a formula is displayed as a percentage? I am
using
an equation from data in numerous cells where the result is displayed as a
percentage. The problem, prior to numbers being entered for the formula
to
calculate, the target cell displays, "#DIV/0!". I understand the formula
is
telling me zeroes have been entered in the data cells, but this is a
calculation template and zeroes are necessary to show folks where the data
needs to be entered. How do I change that display to show "%0.0" without
entering numbers other than zero?