ROUNDUP

Rounds a number up (to a greater value) to the specified number of digits.

Syntax

=ROUNDUP(value, digits)

Arguments

ArgumentTypeDescription
valueNumberThe value to round
digitsNumber(Optional) The number of digits to round the value, defaults to 0

Examples

=ROUNDUP(2.5)3
Rounds the value 2.5 to 1 digit

=ROUNDUP(3.14159, 2)3.15
Rounds the value 3.14159 to 2 digits

=ROUNDUP(-8192, -2)-8100
Rounds the value -8192 to 2 digits