Dividing - Negative Number by Zero
"Jim" wrote:
Looking for a solution of dividing a negative number by zero to show
a result of a negative percentage.
You cannot divide anything by zero, negative or positive.
For Example;
T32=-1.47
S32=0.00
Current formula = =IFERROR(T32/S32,0) resulting in a 100% value
Hmm, that should result in 0%, not 100%.
However I would like the result to show a negative %.
Zero cannot be signed, unless you display it as text (e.g. "-0%").
But if you want plus/minus 100%, which is typical when reporting gains and
losses, you can do the following:
=IFERROR(T32/S32, SIGN(T32))
formatted as Percentage. Note that SIGN() returns -1, 0 and 1 for negative,
zero and positive values. So when S32 is zero, this will return -100%, 0%
and 100% depending on T32.
Is that what you want?
If not, then provide examples of what you for the three values of T32.
|