Change the way a non-computed percentage is displayed

[Guest]

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?

 

[Peo Sjoblom]

If you use

=C2/D2

then you can change it to

=C2/MAX(D2,1)


Regards,

Peo Sjoblom

 

[Guest]

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

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

 

[kjharris123]

The ' /max ' String Worked *great*! Thanks!: