Forum Discussion
Need help with Formula
I am having a hard time figuring out a formula to use. We keep track of our employees personal, vacation, and sick leave in excel. Once sick leave has hit 22.5 hours, the remaining amount is changed ...
Hi Brittni,
For two cells you need two formulas. Into the first one you may add
MAX(<sick leave>, 22.5)
into second one
MAX(0,<sick leave> - 22.5)
How do I add it to the SUM formula already in the cell?
