A bonus spreadsheet is currently set-up to calculate a total bonus and then divides it equally among the total employees with each associate earning the same amount. I need a formula that takes the total bonus to be paid and divides it among the employees based on being full time or part time. With a part timer making half the bonus a full timer earns of the total bonus that is calculated.
Bookmarks