Table of Contents
Summary
The Excel ROUNDUP function returns a number rounded up to the specified number of digits.
Function
=ROUNDUP(number, num_digits)
Arguments (inputs)
number = the number to round, can be a number or a cell reference
num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.
Return value
The ROUNDUP function returns numerical value that is the rounded up value of the number provided.
Example
In the example above the ROUNDUP function rounds the prices in column E down to the next highest integer (0 instructs the ROUNDUP function to round to the integer).
=ROUNDUP(E6,0)
The result returned in cell G6 is $262.
