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.

• 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. ## 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. # 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.