# Need help for vacation accrual

1. ## Need help for vacation accrual

Hello,

I am hoping someone could be of assistance. Does anyone know how to create a maximum amount in the sum from a formula. I am creating a vacation accrual spreadsheet where the number of hours worked dictate the amount accrued, but the problem I am running into is that some employees work a lot of overtime and with the formula I am using to sum up the total for each year ( =40/2080* # of hours) some of the employees worked over 2080 hours, so they are accruing more than one week (40 hours)

YEAR Hours Worked Vacation Hours Accrued Vacation Taken Vacation Paid ACCRUED
2010 3020 58.08 0 0.00 23.44

Thanks,
Ernie

2. ## Re: Need help for vacation accrual

Put this in D2:

=MIN(40,40/2080*C2)

It will ensure that D2 never exceeds 40.

Hope this helps.

Pete

3. ## Re: Need help for vacation accrual

This was exactly what I needed. Thanks again Pete!

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