Ever need to round up to the multiple of a specific number?
Example: I need one full time employee for every 7 agents. But I can't hire 1/7th of an FTE. You could use min/max or IF statements, but =CEILING() is faster. Ceiling will round up to the next multiple of 7. So if I have 6 agents, there is 1 FTE, but if there are 8 agents, it is bumped to two.
Check it out here: https://exceljet.net/excel-functions/excel-ceiling-function
No comments:
Post a Comment