ROUNDUP function

ROUNDUP rounds a number up, away from zero, to a certain precision. See ROUNDDOWN and ROUND for alternatives.

Syntax

ROUNDUP (number, count)

Returns number rounded up (away from zero) to count decimal places. If Count is omitted or zero, the function rounds up to an integer. If count is negative, the function rounds up to the next 10, 100, 1000, and so on.

Example

=ROUNDUP(1.1111,2) returns1.12.

=ROUNDUP(1.2345,1) returns 1.3.

=ROUNDUP(45.67,0) returns 46.

=ROUNDUP(-45.67) returns 46.

=ROUNDUP(987.65,-2) returns 1000.