Is it possible to have a formula to round up or down a number to the nearest 10. So if it's 14, then it will round down to 10 and if 16, it will roundup to 20?
Is it possible to have a formula to round up or down a number to the nearest 10. So if it's 14, then it will round down to 10 and if 16, it will roundup to 20?
Formula:Please Login or Register to view this content.
where your 14 is in o33
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Thank you for this. If i wanted to roundup to the nearest 10, how would I do this?
the previously posted formula should already do that. Unless you mean always round up to the nearest 10?
Then it would be
Formula:Please Login or Register to view this content.
Hi, Yes I'd like to have it roundup to the nearest 10 or 20. Is that possible?
the nearest 10 is what I posted above. To round to nearest 20 would be:
Formula:Please Login or Register to view this content.
In such case you will have to use MROUND function
Assume you have value in A1
Try
B1=MROUND(A1,10)
Excel 2016 (Windows) 64 bit
A B 1 16 20
Sheet: Sheet1
Excel 2016 (Windows) 64 bit
A B 1 14 10
Sheet: Sheet1
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks