Is there a way I can have a cell round a number to the the nearest 5? For example, the number 114 would round to 115, or 62 would round to 60
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
@Lance Roberts answer picks up on the built in formula for this... but you can also "cheat" your way there as well:
In other words, divide the target by 5, round to the nearest whole number, and then multiply by 5. For your examples, this does:



Use the following formula (example for A1):


