Re: Excel Formula Negative/Negative =+%

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"BigDon" <BigDon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B10D8375-FCE5-49A9-9A5D-3DD2C39C5868@xxxxxxxxxxxxxxxx
>
> 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.




.

Relevant Pages