Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate year vs. year sales in a percentage?
For example.
Fiscal year 06 sales of 1000 fiscal year 07 sales 1200 07 vs 06 sales are up x% |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate year vs. year sales in a percentage?
=(1200/1000)-1 = 20%
Dave -- Brevity is the soul of wit. "johngalt" wrote: For example. Fiscal year 06 sales of 1000 fiscal year 07 sales 1200 07 vs 06 sales are up x% |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate year vs. year sales in a percentage?
06 sales in A1, 07 sales in A2
For x, use the formula =(A2/A1)-1 and format as percentage. Other options include =(A2-A1)/A1. If you want to use the percentage value as a number in its own right in further calculations (the number 20 in your case), then multiply the result by 100. -- David Biddulph "johngalt" wrote in message ... For example. Fiscal year 06 sales of 1000 fiscal year 07 sales 1200 07 vs 06 sales are up x% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONDITIONAL FORMULA | New Users to Excel | |||
Calculate Sales Amount | Excel Discussion (Misc queries) | |||
HOW DO I CALCULATE A RUNNING PERCENTAGE | Excel Discussion (Misc queries) | |||
how do i calculate principal payed in one year in excel | New Users to Excel | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions |