Excel Formula Negative/Negative =+%

I am trying to write a formula to correct negative %.....
Example....-500 2005 -400 for 2004 Variance = -100

Variance % is showing 25% should be (-)25%......How to write formula?

"BigDon" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to write a formula to correct negative %.....
> Example....-500 2005 -400 for 2004 Variance = -100
>
> Variance % is showing 25% should be (-)25%......How to write
> formula?
>

Hi,

First, I would suggest considering whether you actually want -25% in
that case - the figures has actually increased by 25%.

However, to answer your question:

I am assuming that you want the percentage sign to match the variance
sign?

If you have the 2004 / 2005 numbers in columns A and B and the
variance in column C (say, C5) = -100

and your percentage calculation is in D5 then you could do something
like this:

D5 = SIGN(C5)*ABS(C5/A5)


HTH,

Alan.