# Manuals/calci/ROUND

ROUND(Number,Decimals)

• Where 'Number' is the number to round and
• 'Decimals' is the number of digits to which the number is to be rounded.
• ROUND() rounds a number to specified number of digits.

## Description

ROUND(Number,Decimals)

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 'Decimals' 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 Decimals > 0.
• The number is rounded to the nearest integer, if Decimals = 0.
• The number is rounded to the left of the decimal point, if Decimals < 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 2.5 to 6 in steps of 0.5.

Number ROUND
2.5 3
3 3
3.5 4
4 4
4.5 5
5 5
5.5 6
6 6
• ROUNDUP() can be used to round a number away from zero.
• ROUNDDOWN() can be used to round a number towards zero.
• MROUND() can be used to round a number to desired multiple.

## Examples

 Function Output ROUND(3.6712,2) 3.67 ROUND(99.37,0) 99 ROUND(99.37) 99 ROUND(145.8,-1) 150 ROUND(-89.65,1) -89.7 ROUND(-89.65,-1) -90

## Related Videos

ROUNDING DECIMALS