"Jim" wrote:
Thanks. What I'm going to use so I can quickly identify -% is the
following;
=IF(ISERROR(T3/S3),"n/a",(T3/S3)) which I believe Fred was trying to tell
me last evening.

Actually, Fred suggested:

=IF(S3=0, "n/a", T3/S3)

But if you have IFERROR (Excel 2007), you could simply modify your original
formula as follows:

=IFERROR(T3/S3, "n/a")


----- original message -----

"Jim" wrote in message
...
Thanks. What I'm going to use so I can quickly identify -% is the
following;
=IF(ISERROR(T3/S3),"n/a",(T3/S3)) which I believe Fred was trying to tell
me
last evening.

"JoeU2004" wrote:

"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.