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 ...
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?
Like this, maybe:
John has sick leave in column B. The total sum is 28 hours. Cell B10 shows only 22.5 of those hours and the remainder of 5.5 hours is showing in cell B11.
Jim has 17 hours sick leave and all his hours are in C10.
Here are the formulas used in column B.
=SUM(B3:B7) =MIN(SUM(B3:B7),22.5) =IF(SUM(B3:B7)>22.5,SUM(B3:B7)-22.5,0) Let me know if that helps.
