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
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
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
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" <klhering@discussions.microsoft.com> wrote in message
news:7427401D-59AC-4771-9F4F-CE1C67ED34F7@microsoft.com...
>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
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" <klhering@discussions.microsoft.com> wrote in message
> news:7427401D-59AC-4771-9F4F-CE1C67ED34F7@microsoft.com...
> >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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks