# Rounding to nearest 0.25

Options
✭✭✭✭✭✭
edited 12/09/19

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.

Tags:

• ✭✭✭✭✭✭
Options

Try using the CEILING function.

=CEILING(number, .25)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!