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)
-
This content has been removed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!