Hi,
I have no idea how to do this ... hopefully it's possible.
I'm trying to determine how much vacation a person accrues during the fiscal year (10/1/03 - 9/30/04).
All staff accrue 8.667 hours/mo when they are on staff 1-48 months. They then begin to accrue 10 hours/mo when they've been on staff 49-108 months. 109 months on, they accrue 13.334 hours/mo.
I originally had used this formula and thought I had it: =IF(G4<12,G4*6.667,IF(G4<48,12*6.667,IF(G4<108,12*10,IF(G4>=108,12*13.334)))). (G4 refers to the cell which contains the # of months a person has been on staff.)
However, what this formula doesn't account for is if someone switches to a new accrual rate mid-year. I am drawing a complete blank on how to set this up formula-wise.
I would greatly appreciate any suggestions anyone can give!
ray:
I have no idea how to do this ... hopefully it's possible.
I'm trying to determine how much vacation a person accrues during the fiscal year (10/1/03 - 9/30/04).
All staff accrue 8.667 hours/mo when they are on staff 1-48 months. They then begin to accrue 10 hours/mo when they've been on staff 49-108 months. 109 months on, they accrue 13.334 hours/mo.
I originally had used this formula and thought I had it: =IF(G4<12,G4*6.667,IF(G4<48,12*6.667,IF(G4<108,12*10,IF(G4>=108,12*13.334)))). (G4 refers to the cell which contains the # of months a person has been on staff.)
However, what this formula doesn't account for is if someone switches to a new accrual rate mid-year. I am drawing a complete blank on how to set this up formula-wise.
I would greatly appreciate any suggestions anyone can give!
ray: