Manuals/calci/ROUND

ROUND(number, num_of_digits)

• Where 'number' is the number to round and
• 'num_of_digits' is the number of digits before or after decimal point.

ROUND() rounds a number to specified number of digits.

Description

ROUND(number, num_of_digits)

This function is used to round a number to certain number of digits mentioned in the argument.

For Example,

ROUND(3.6712,2) returns 3.67 as a result.

ROUND(411.3,-1) returns 410 as a result.

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

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

ROUND(2.5..6..0.5) that rounds the numbers from 2.5 to 6 in steps of 0.5.

Number	ROUND Output
2.5	3
3	3
3.5	4
4	4
4.5	5
5	5
5.5	6
6	6

Examples

Function	Output
3.6712	2
3.67