Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to figure out percentage of change for 5 years
I have an excel project that lists student hours for 5 seperate years then I
have an average column, my problem now is that I need to add a column with a 5 year percentage change. Does anyone know what formula I could use for this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to figure out percentage of change for 5 years
Can you elaborate a bit? you have 5 cells with student hours, 1 for each
year. you have a cell with the average of these cells. What are you wanting to compare to get the percentage? the average divided by? "klhering" wrote: I have an excel project that lists student hours for 5 seperate years then I have an average column, my problem now is that I need to add a column with a 5 year percentage change. Does anyone know what formula I could use for this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to figure out percentage of change for 5 years
If you just want the total change over the 5 years, it's:
(EndingHours - StartingHours) / StartingHours So I don't understand what the separate column is for, because you would have only one number as a result. Are you sure they are not asking for the change from each year to year? -- Regards, Fred "klhering" wrote in message ... I have an excel project that lists student hours for 5 seperate years then I have an average column, my problem now is that I need to add a column with a 5 year percentage change. Does anyone know what formula I could use for this? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to figure out percentage of change for 5 years
Fred-thanks for the help--yes I just want the total change over the 5
years--so do you think I should use my average of the 5 years as my ending hours and the first year listed as my starting hours? Thanks K.Hering "Fred Smith" wrote: If you just want the total change over the 5 years, it's: (EndingHours - StartingHours) / StartingHours So I don't understand what the separate column is for, because you would have only one number as a result. Are you sure they are not asking for the change from each year to year? -- Regards, Fred "klhering" wrote in message ... I have an excel project that lists student hours for 5 seperate years then I have an average column, my problem now is that I need to add a column with a 5 year percentage change. Does anyone know what formula I could use for this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula to help me calculate years of vesting for 401K. | Excel Worksheet Functions | |||
Calculating deviation from mean and % change for varying years | Excel Discussion (Misc queries) | |||
Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |