@ROUNDUP

Rounds up a number to a specified number of digits. For example, if cell A.1 contains 2.149, and you want to round that value up to one decimal place, you can use the following formula: @ROUNDUP(A1,1). The result is 2.2.

Syntax

@ROUNDUP(V1, V2)

Argument	Description
V1	Required. The number you want to round up.
V2	Required. The number of digits to which you want to round up the number argument.

Notes

• The function tries to round a number away from zero; after rounding, a positive number would become more positive, while a negative number would become more negative.
• If the number of digits is positive, the number is rounded up to the specified number of decimal places.
• If the number of digits is zero, the number is rounded up to the nearest integer.
• If the number of digits is negative, the number is rounded up to the left of the decimal point.

Examples

@ROUNDUP(3.2, 0) = 4

@ROUNDUP(76.9, 0) = 77

@ROUNDUP(3.14159, 3) = 3.142

@ROUNDUP(-3.14159, 1) = -3.2

@ROUNDUP(31415.92654, -2) = 31500