Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |