Dividing - Negative Number by Zero
You're getting the result of 100% because the answer to your Iferror
statement is True (ie, dividing by zero is an error), which as a number is
1, which formatted as a percent is 100%.
You don't say what result you want when dividing by zero (negative percent
of what?), so just fill it in in the following formula:
=if(s32=0,"the answer you want",t32/s32)
Regards,
Fred.
"Jim" wrote in message
...
Looking for a solution of dividing a negative number by zero to show a
result
of a negative percentage.
For Example;
T32=-1.47
S32=0.00
Current formula = =IFERROR(T32/S32,0) resulting in a 100% value
However I would like the result to show a negative %.
Thank You
|