Function Index

Round

Round a number to the specified number of digits.

Usage

Round(<number>,<digits>)

number (required) Number to be rounded.

digits (optional) Number of decimal places to which to round.

NOTE: A negative digits value will return an integer with than many least-significant digits zeroed.

Examples

Round(Pi(), 2)
  • Returns 3.14
Round(3.1, 2)
  • Returns 3.1
  • Rounding is different than formatting: The result may have fewer digits than specified. Rounding does not add trailing zeroes.
Round(1234, -2)
  • Returns 1200