Manuals/calci/ROUNDUP

ROUNDUP(number, num_of_digits)

• Where 'number' is the number to round and
• 'num_of_digits' is the number of digits to which the number is to be rounded.

ROUNDUP() rounds a number to specified number of digits away from 0.

Description

ROUNDUP(number, num_of_digits)

This function is used to round a number up away from zero, to specified number of decimal digits mentioned in the argument.

For Example,

ROUNDUP(67.8,0) returns 68 as a result.

ROUNDUP(6.83112,3) returns 6.832 as a result.

• If 'num_of_digits' is omitted, Calci displays #NaN error message.
• The number is rounded up to the specified number of decimal places, if num_of_digits > 0.
• The number is rounded up to the nearest integer, if num_of_digits = 0.
• The number is rounded up to the left of the decimal point, if num_of_digits < 0.
• If any argument is non-numeric, Calci displays #NaN error message.

ROUNDUP() can also be used for multiple number array as -

ROUNDUP(2.55..7.55,1) that rounds the numbers from 2.5 to 6 in steps of 0.5.

Number	ROUNDUP
2.5	3
3	3
3.5	4
4	4
4.5	5
5	5
5.5	6
6	6

• ROUND() can be used to round a number to specified number of digits.
• ROUNDDOWN() can be used to round a number towards zero.
• MROUND() can be used to round a number to desired multiple.