fbpx
Select Page

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

See Also

Ceiling
Floor

More About Math Functions

These functions return well-known mathematical constants or implement common arithmetic functions.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.