ROUNDUP

The ROUNDUP function rounds a number up, away from zero, to a specified number of decimal places.

Syntax

=ROUNDUP(number, num_digits)

Parameters

• number: The number you want to round up
• num_digits: The number of digits to round to (positive for decimals, negative for left of decimal)

Examples

=ROUNDUP(3.2, 0) // Returns 4
=ROUNDUP(123.456, 2) // Returns 123.46
=ROUNDUP(123.456, -2) // Returns 200