| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Year-over-year percentage of change
I am trying to find the percentage of change in customers. This wouldn't be a
problem with the formula =IF(C35=0,D35,(D35-C35)/C35). However, the problem arises when one of the cells is 0. So in this case let's say D35 is 35 and C35 is 0. This returns a percent of increase of 3500%. Here is a snapshot of the data I am having problems with Thru 0908 2005 AVG 2006 AVG 2007 AVG 2008 AVG (prod introduced) 0 0 35 36 I am then using all of the percentages of change found to determine and average change for the 4 years. The 3500% throughs the calcuation off. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Calculate Compounded Percentage Per Year | Excel Discussion (Misc queries) | |||
| need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
| change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
Threaded Mode
