ROUND() : round a number

The ROUND() function rounds a numeric value to the desired number of decimal places, and returns a number. The precision parameter is optional: it can be negative to round to the left of the decimal point (tens, hundreds, etc.).

ROUND() rounds to the nearest value at the requested precision: 5 and above rounds up, below 5 rounds down. Without the precision parameter, the value is automatically rounded to the nearest integer.

Syntax

ROUND(value)
ROUND(value, precision)

Calling function parameters in TimeTonic:

$field_name = field (link, linked table column, number, selection, formula, text...).
"free text" = free text to be added between quotation marks.
Do not use quotation marks for numbers.

Parameters

# Parameter Description

1 value Number to round.

2 precision (optional) Number of decimal places to keep. Defaults to rounding to the nearest integer. Can be negative to round to the left of the decimal point (tens, hundreds, etc.).

Comparing INT, FLOOR and ROUND

These three functions round differently. Here is how to tell them apart.

Function	Behavior	Example
INT()	Returns the integer part of a number by rounding it down.	INT(-3.7) → -4
FLOOR()	Rounds down to the nearest integer less than or equal to the value.	FLOOR(7.5) → 7
ROUND()	Rounds a numeric value to the desired number of decimal places.	ROUND(3.14159, 2) → 3.14

The output format (integer or decimal) can be configured in the output field options of the formula editor. See Output format options in the Formula column article.

Examples

Rounding to two decimal places

ROUND(3.14159, 2)

Result: 3.14

Rounding to the nearest integer (no precision)

ROUND(37.2)

Result: 37

Rounding to the nearest hundred (negative precision)

ROUND(1234, -2)

Result: 1200

Go further

INT()

Truncate a number to its integer part, with no rounding rule.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.