I'm trying to get a formula that rounds to multiples of 5. For example, if an answer is 63, I want it to be 65. If it's 72, I'd like it to be 70. I'm currently stumped for an answer
I'm trying to get a formula that rounds to multiples of 5. For example, if an answer is 63, I want it to be 65. If it's 72, I'd like it to be 70. I'm currently stumped for an answer
Assuming you want to round 2.5 and 7.5 (halfway marks) always up, you can use the MROUND() function for this: =MROUND(value,5) https://support.office.com/en-us/art...b-d2d5b3baf427
Originally Posted by shg
use ceiling
=CEILING(62,5)
Thank you both for the help, it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks