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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks