I need help creating an excel formula. I have a spreadsheet that calculates
employee paid time off based on years of employment, but there is a cap. So,
I need to create a formula that indicates that time off is accrued at a
specific rate, unless the time cap has been reached, in which case the cap
amount is reflected. I know it is an "IF" formula but can't get it to work.

Any help is appreciated!

Thanks,
--
Christina