+ Reply to Thread
Results 1 to 4 of 4

Need formula to figure out percentage of change for 5 years

  1. #1
    klhering
    Guest

    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. #2
    tim m
    Guest

    RE: 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. #3
    Fred Smith
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    >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. #4
    klhering
    Guest

    Re: 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" <[email protected]> wrote in message
    > news:[email protected]...
    > >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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1