Round to the Nearest Multiple Other Than 10

If you want to round a price to nearest nickel (multiple of 0.05), or a length to the nearest inch (multiple of 1/12), or a number of minutes to the nearest second (multiple of 1/60), you can use the following formula (where mult is the multiple to round to):=ROUND(number/mult,0)*multor just=MROUND(number,mult)(Thanks to mmmoj's comment for the MROUND function)If you want to round UP or DOWN, you