The ROUNDUP function rounds up a number to a specified number of digits or decimals. In this guide, we’re going to show you how to use the ROUNDUP function and also throw in some tips and error handling methods.


Supported versions

  • All versions

Syntax

ROUNDUP(number,[num_digits])


Arguments

number The number to be rounded.
[num_digits] The number of digits.


Examples

Firstly a reminder: Named ranges are added to ease of reading formulas.

Example 1

=ROUNDUP(314.159265358979,2)
formula returns 314.16; because when num_digits is greater than 0, then number is rounded up to the specified number of decimal places.

ROUNDUP Function

Example 2

=ROUNDUP(314.159265358979,0)
formula returns 315; because when num_digits is equal to 0, then number is rounded up to the nearest integer.

Example 3

=ROUNDUP(314.159265358979,-2)
formula returns 400; because when num_digits is less than 0, the number is rounded up to the left of the decimal point.

Download Workbook


Tips

  • Unlike generic rounding, the ROUNDUP function rounds all numbers 1 to 9 up.
  • Use the ROUND for standard rounding.
  • Use the ROUNDDOWN to always round down.