How to use Excel ROUNDUP Function

0
163

This article demonstrates how to use Excel ROUNDUP function with syntax and examples.

The Excel ROUNDUP function returns a supplied number rounded up (away from zero) to a given number of digits.

Uses: Excel ROUNDUP Function

The ROUNDUP function used to round a number up to the next possible value away from 0 (zero). Suppose there is a number, which is supposed to be rounded down, but using ROUNDUP function rounds the number up.

For example, =ROUNDUP (13.03, 0) rounds 13.03 to next tens with the result of 14.

Syntax:

The function follows the same syntax as Excel ROUND function.

ROUNDUP (number, num_digits)

Arguments:

  • number: the number you want to round up.
  • num_digits: the number of decimal places to round the number to.

Examples: Excel ROUNDUP Function

Let’s take some of the examples to explore how to use the ROUNDUP function in excel on real-life data.

excel roundup nearest 10

Notice that for 2nd row, a digit after 2 places to the right of the decimal is less than five (5) however, the rounding digit is still increased by one with the result of 20.36 for number 20.35241.

Finally, on row 5, num_digit supplied ‘-3’ for the number ‘1232.82’ in cell A5 that instructs ‘ROUNDUP’ to round the number up to the next thousandths value, i.e. 2000.

Additional Notes: –

  • The number argument can be a number, reference to a cell containing numbers or numbers returned by some formulas.
  • If num_digit is 0, the number is rounded up to the possible integer.
  • If num_digit is below 0, the number is rounded up to the left of the decimal point (i.e. to the nearest tenth, hundredth, thousandth, etc.).
  • ROUNDUP returns #VALUE! error if any of the argument is supplied with a non-numeric value.
  • It returns the answer to the same sign as the number
  • ROUNDUP always round the numbers 1-9 up.
  • The ROUNDUP function can round either to the right or left of the decimal point.
    • If num_digit is above zero (0), the number is rounded up to the specified number of decimal digits to the right of decimal point.

Related Tips:-

INT | ROUNDDOWN | ROUNDMOD

LEAVE A REPLY

Please enter your comment!
Please enter your name here