software

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, quot;#DIV/0!quot;. 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 quot;%0.0quot; without
entering numbers other than zero?

If you use

=C2/D2

then you can change it to

=C2/MAX(D2,1)Regards,

Peo Sjoblomquot;Mike800Wquot; gt; wrote in message
...
gt; How do I change the way a formula is displayed as a percentage? I am
gt; using
gt; an equation from data in numerous cells where the result is displayed as a
gt; percentage. The problem, prior to numbers being entered for the formula
gt; to
gt; calculate, the target cell displays, quot;#DIV/0!quot;. I understand the formula
gt; is
gt; telling me zeroes have been entered in the data cells, but this is a
gt; calculation template and zeroes are necessary to show folks where the data
gt; needs to be entered. How do I change that display to show quot;%0.0quot; without
gt; 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)

quot;Peo Sjoblomquot; wrote:

gt; If you use
gt;
gt; =C2/D2
gt;
gt; then you can change it to
gt;
gt; =C2/MAX(D2,1)
gt;
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;Mike800Wquot; gt; wrote in message
gt; ...
gt; gt; How do I change the way a formula is displayed as a percentage? I am
gt; gt; using
gt; gt; an equation from data in numerous cells where the result is displayed as a
gt; gt; percentage. The problem, prior to numbers being entered for the formula
gt; gt; to
gt; gt; calculate, the target cell displays, quot;#DIV/0!quot;. I understand the formula
gt; gt; is
gt; gt; telling me zeroes have been entered in the data cells, but this is a
gt; gt; calculation template and zeroes are necessary to show folks where the data
gt; gt; needs to be entered. How do I change that display to show quot;%0.0quot; without
gt; gt; entering numbers other than zero?
gt;
gt;
gt;


The ' /max ' String Worked *great*! Thanks!--
kjharris123
------------------------------------------------------------------------
kjharris123's Profile: www.excelforum.com/member.php...oamp;userid=29715
View this thread: www.excelforum.com/showthread...hreadid=525376