| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Difference as a Percentage
I have volume data for 2007 and 2008. I am trying to show the difference
between the two numbers as a percentage. Example: 2007 Volume was 400, 2008 Volume was 550. The difference is 150. How do I express that 150 as a % of change or % difference -- V_Ernst |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show Difference as a Percentage
A1: 400
B1: 550 C1: =IF(A1=0,"",(B1-A1)/A1) format C1 as percentage. -- ** John C ** "V_Ernst" wrote: I have volume data for 2007 and 2008. I am trying to show the difference between the two numbers as a percentage. Example: 2007 Volume was 400, 2008 Volume was 550. The difference is 150. How do I express that 150 as a % of change or % difference -- V_Ernst |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Difference Between Budget & Actual | Excel Discussion (Misc queries) | |||
| Difference between three numbers in percentage | Excel Discussion (Misc queries) | |||
| Calclulating percentage difference | New Users to Excel | |||
| Percentage of difference formula | Excel Discussion (Misc queries) | |||
| percentage difference | New Users to Excel | |||
Linear Mode
