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 ...
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.
Brittni, could you please give us small sample, just one record, how your data is structured and what exactly do you sum?
