Rounding to nearest 0.25

jb@59069

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.

Paul Newcome

Try using the CEILING function.

 

=CEILING(number, .25)

Unknown

This content has been removed.