Skip to content

How to round to the nearest multiple of x in Excel

I’m no Excel guru, but still I’m surprised I’ve never stumbled across this function before.

While trying to replicate a set of data related to a test my daughter did for ski training, I noticed that to give a score they rounded up a percentage to the nearest 5 (5, 10, 15, 20,…). Which left me thinking – how do I do that?

Obvious solution, Google it. So now I know about Ceiling (number, significance)

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *