Hi. New here, and I need help! I am "formula" and "function" handicapped!
For a small church semi-monthly payroll, I'm developing an Excel worksheet to track vacation & sick leave beginning balances (Column A - a hard # will be entered), hours used this pay period (Column B - a hard # will be entered each pay period), hours accrued this pay period (Column C - need a formula here based on 4 hours max accrual, but less if it causes the ending bal to exceed 96) and ending balance (Column D - need another formula here... beg bal, minus usage, plus accrual, the sum of which cannot exceed 96 for a full-time [40 hour/wk] employee).
If anyone here can help, I would sure appreciate it!
Thanks.