Manuals/calci/ROUND

From ZCubes Wiki
Revision as of 12:24, 27 November 2013 by Swapna (talk | contribs)
Jump to navigation Jump to search

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 the number to specified number of digits.

Description

ROUND(number, num_of_digits)

For Example,

ROUND(3.6712,2) returns 3.67

  • When Nd is greater than zero,the number is rounded to the specified number of decimal places.
  • When Nd is 0, the number is rounded to the nearest integer.
  • When Nd is less than 0, the number is rounded to the left of the decimal point.


Examples

Function Output
3.6712 2
3.67