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?

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?

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?

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


--
kjharris123
------------------------------------------------------------------------
kjharris123's Profile: http://www.excelforum.com/member.php...o&userid=29715
View this thread: http://www.excelforum.com/showthread...hreadid=525376