The ROUND function rounds a number to a specified number of digits. For example, if Field 1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

=ROUND([Field 1], 2)

The result of this function is 23.78

Syntax

ROUND(number, [nummberOfDigits])

The ROUND function syntax has the following arguments:

  • number Required) The number that you want to round.
  • numberOfDigits (Required) The number of digits to which you want to round the number argument.

Remarks

  • If numberOfDigits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
  • If numberOfDigits is 0, the number is rounded to the nearest integer.
  • If numberOfDigits is less than 0, the number is rounded to the left of the decimal point.
  • To always round up (away from zero), use the CEILING function.
  • To always round down (toward zero), use the FLOOR function.

Examples

Formula

Description

Result

=ROUND(2.15, 1)

Rounds 2.15 to one decimal place

2.2

=ROUND(2.149, 1)

Rounds 2.149 to one decimal place

2.1

=ROUND(-1.475, 2)

Rounds -1.475 to two decimal places

-1.48

=ROUND(21.5, -1)

Rounds 21.5 to one decimal place to the left of the decimal point

20

=ROUND(626.3, -3)

Rounds 626.3 to the nearest multiple of 1000

1000

=ROUND(1.98, -1)

Rounds 1.98 to the nearest multiple of 10

0

=ROUND(-50.55, -2)

Rounds -50.55 to the nearest multiple of 100

-100