Need formula to figure out percentage of change for 5 years


G

Guest

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
 
Ad

Advertisements

G

Guest

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?
 
F

Fred Smith

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?
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top