excel formula

  • Thread starter Thread starter Tankman
  • Start date Start date
T

Tankman

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?
 
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?
Click to expand...
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)
 
Back
Top