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 from sick leave to personal leave. I need a formula that once the amount is greater than 22.5 hours is transferred over to another cell and added to the sum of that cell. I don't know if I need two formulas for that. I have been stuck with this for weeks and I need some help figuring this out. Thank you!
- How do I add this formula to the formula already in the cell? I have the SUM formula in the cell.
Like
=SUM(<something else>) + MAX(<sick leave>, 22.5)
I don't want to ADD it to the formula, I want to incorporate it into the formula with the SUM. I need the cell to add the SUM and then if it equals more than 22.5, I need it to send the remaining balance to the other cell and add it to the SUM.
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?
