Excel Formula Negative/Negative =+%

[Guest]

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?

 

[Alan]

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.