Manuals/calci/ROUND

Revision as of 17:36, 27 November 2013 by Swapna (talk | contribs)

ROUND(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.

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 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

See Also

References