View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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