I have the following calculation to calculate the number of days available to a person for vacation leave.
I17 is previous total, C18 is the new accrued amount, and F18 is the amount of time used.
I want the new answer to test to see if the person has gone over 120 hours. If they have, then I want the answer to be 120 for any calculation that equals more than 120 hours.
How do I write the if, then statement for this?
Thank you!
=SUM(I17,C18)-F18
Bookmarks