Office 365 Excel Roundup function allows you to round a number to the nearest whole number or nearest 10s or 100s. Below are detailed examples of Roundup() function plus instructions on rounding up to nearest multiples.

Syntax

ROUNDUP (number, num_digits)

number: the number to round up

num_digits: specified digit to round up to. 0 rounds up to the nearest integer. -1 will round up to the nearest 10, -2 to nearest 100 etc. 1 will round up to the nearest one decimal, 2 to the nearest two decimals etc

Usage

ROUNDUP () function rounds a number to a specified number of digits.

Example

FormulaResult
=ROUNDUP(-3.22, 0)-4
=ROUNDUP(2.45, 1)2.5
=ROUNDUP(2.45, -1)10

Excel Roundup to Nearest 5

To round to nearest multiple, say 5, use MROUND() function.

=MROUND($A15, 5)

Change the second argument to -5 if the first argument is a negative number.

Excel Roundup to Nearest 10

To round to nearest multiple, say 5, use MROUND() function.

=MROUND($A15, 10)

Change the second argument to -10 if the first argument is a negative number.

Excel Round to Nearest 100

To round to nearest multiple, say 5, use MROUND() function.

=MROUND($A15, 100)

Change the second argument to -100 if the first argument is a negative number.

How to Roundup a Formula Result in Excel

To round a formula result in Excel, refer to the cell address of the result in the first argument of Roundup() function.

For example, if you have in cell A1 the result 125.71 from a formula, you can round up the result in cell B1 to the nearest integer with this formula:

=ROUNDUP(A1, 0)

Alternatively, you can also put the formula in the first argument in lieu of A1 in this example.

Excel Roundup Not Working

If ROUNDUP() function is not working as expected, check that the cells are treated as numbers by Excel.

Note that text is default to align left. If the numbers are aligning to the left with a green triangle, select those cells. You will then see a small asterisk warning. Click on the warning, it should say “Number stored as text”.

Select the “Convert to number” option to convert them all to numbers.


Related Post

Round of Numbers in Excel

Pin It on Pinterest

Share This