Thanks JE, but this returned 0%, for example: (10-8)/8 = 25%,
(a2-b2)/b2 = 25%
if b2 would = 0, i want the result to be 100%
Tom
"JE McGimpsey" wrote:
One way:
Assuming your divisor is in B1 and your dividend in A1:
=IF(B1=0,SIGN(A1),A1/B1)
Format the cell as a percentage.
In article ,
"sony654" wrote:
I am dividing number by "0", and want the result to be 100%, or -100%. For
example: -.06/0 should equal -100%. how do I address in the formula? Thanks.
|