Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

ROUNDUP function

ROUNDUP(Number, DigitCount?) ROUNDUP(Number; DigitCount?)

Number

Number or { Number }

The number to be rounded.

DigitCount

Number or { Number } (optional)

The number of decimal places the resulting number should have, if the number is positive. If the number is negative, the number is rounded to the left of the decimal separator. If omitted, it is assumed to be 0, meaning that this function returns an integer.

Returns

Number or { Number }

A rounded number.

Returns a number rounded up to a certain precision. ROUNDUP(1.4)ROUNDUP(1,4) returns 2.

If the number of digits is not specified, 0 is assumed, which means that this function returns integers (whole numbers).

If the number if digits is positive, the parameter is interpreted as the number of decimal places the number should be rounded up to. ROUNDUP(1.41, 1)ROUNDUP(1,41; 1) returns 1.5 (one decimal place).

If the number of digits is negative, the number is rounded to the left of the decimal separator. ROUNDUP(123456789, -3)ROUNDUP(123456789; -3) returns 123457000 and ROUNDUP(123456789, -6)ROUNDUP(123456789; -6) returns 124000000.

Examples

ROUNDUP(1.4)ROUNDUP(1,4)

Returns 2.

ROUNDUP(1.41, 0)ROUNDUP(1,41; 0)

Returns 2.

ROUNDUP(1.41, 1)ROUNDUP(1,41; 1)

Returns 1.5.

ROUNDUP(123456789, -3)ROUNDUP(123456789; -3)

Returns 123457000.

ROUNDUP(123456789, -6)ROUNDUP(123456789; -6)

Returns 124000000.

ROUNDUP(1.49, { 0, 1 })ROUNDUP(1,49; { 0; 1 })

Returns the array { 2, 1.5 }{ 2; 1,5 }.

{ ROUNDUP(1.49, 0), ROUNDUP(1.49, 1) }{ ROUNDUP(1,49; 0); ROUNDUP(1,49; 1) }

Returns the array { 2, 1.5 }{ 2; 1,5 }.