Rounding to nearest 0.25
Hello all
We have need of some rounding help, please.
We have a column for Time Worked that is a dropdown with selections of 0.00, 0.25, 0.50, 0.75, 1.00, 1.25, etc. all the way to 24 hours.
I have need to compensate for some rate variances and be able to round the results to the corresponding Time Worked values.
I.e., if an entry in Time Worked is 2.75, I need to multiply by 187.5 or 175, then divide that sum by 150, take the result and round up.
Example:
2.75 * 187.5 = 515.625 / 150 = 3.4375  Need to round to 3.50
2.75 * 175 = 481.25 / 150 = 3.208333  Need to round to 3.25
4.25 * 187.5 = 796.875 / 150 = 5.3125  Need to round to 5.50
6.75 * 175 = 1181.25 / 150 = 7.875  Need to round to 8.00
Etc., etc., etc.
Thank you for any help.
Comments

Try using the CEILING function.
=CEILING(number, .25)
Help Article Resources
Categories
Check out the Formula Handbook template!