excel formula
On Apr 30, 3:23 pm, Tankman wrote:
What is the formula for showing the difference as a % between 2 values, i.e.
Value 1 : April 2007 Spend is £2,404.65
Value 2 : April 2008 Spend is (minus) -£433.00
I'm using Windows XP Professional & Office 2003.
Can anyone help me?
The only trick is getting the sign correct, otherwise this is just a
math question. I believe this is the answer.
=(Value2-Value1)/ABS(Value1)
And you either need to format the cell as percent or add *100 to the
formula.
I suppose you might want a percent of the 2nd figure in some
situations.
=(Value2-Value1)/ABS(Value2)
|