• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • EXP function
  • FV function
  • LOG function
  • MAX function
  • MEDIAN function
  • MIN function
  • MKDEC function
  • MKINT function
  • MOD function
  • POS function
  • PV function
  • R function
  • RATIO function
  • RC function
  • RCNV function
  • RCR function
  • RCTOTAL function
  • ROUND function
  • ROWCOUNT function
  • RR function
  • RRTOTAL function
  • STDDEV function
  • SUM function
  • TOTAL function

ROUND Function

The ROUND function rounds a number by the specified factor. The rounding options are "0" to round to 1s, "1" to round to thousands, "2" to round to millions, and "-1" to use the document defaults. The optional pad zero parameters are "0" does not pad the number, "1" pads the truncated numbers with zeros, and "-1" uses the active document defaults.

Syntax

ROUND(value, divisor value, <pad zeroes>)

Example 1

ROUND(15.89)

Returns the value 16, rounded by 1s.

Example 2

ROUND(1600, 1)

Returns the integer 2, which is 1600 rounded by 1000s and then displayed as the closest integer.

Example 3

ROUND(1600,1,1)

Returns the value 2000, which is 1600 rounded by 1000s and then padded with the appropriate number of zeros.

Related Topics

• Mathematical and Financial Functions