Excel Rounding to nearest multiple of XX

Excel Rounding to nearest multiple of XX 

Given a column of numbers

 we want to round to the nearest multiple of 5 Or 50

EXAMPLE :

If you have the analyst tool pak installed, use
=MROUND(A1,5)

=MROUND(A1,50)

Otherwise you could use
=ROUND(A1/5,0)*5

=ROUND(A1/50,50)*50

Categories: ROUND