ROUNDUP

Returns the specified number, rounded up (away from zero) to the specified number of digits.

Syntax

ROUNDUP( Number n, [Integer digits = 0] ) → Number

Parameters

n

Required. The number to round.

digits

Optional. The number of digits to round to. If omitted, digits is assumed to be 0.

Remarks

If digits is greater than 0, the number is rounded to the specified number of decimal places. If digits is 0, the number is rounded up to the nearest integer. If digits is less than 0, the number is rounded to the left of the decimal point. If digits is not integer, it is automatically truncated.

Example

Formula

=ROUNDUP(2.15,1)
=ROUNDUP(21.5,-1)

See Also

Function Reference
TRUNC Function
INT Function
ROUND Function
ROUNDDOWN Function