Rounding to nearest multiple in Excel

• ROUND
• OKRVVERH
• BLOOD DOWN

This example will demonstrate the work of three functions for rounding numbers to a multiple in Excel: MROUND (RUGLT), CEILING (OKRVVERH) and FLOOR (OKRVNYZ).

ROUND

1. For example, let’s round the number to the nearest multiple of 10.

   =MROUND(A1,10)

   =ОКРУГЛТ(A1;10)

2. Now round the number to the nearest multiple of 5.

   =MROUND(A1,5)

   =ОКРУГЛТ(A1;5)

   

OKRVVERH

Works just like MROUND (ROUND), but rounds up to a higher multiple.

=CEILING(A1,10)

=ОКРВВЕРХ(A1;10)

BLOOD DOWN

Works just like MROUND (ROUND), but rounds down to a lower multiple.

=FLOOR(A1,5)

=ОКРВНИЗ(A1;5)