ROUND function

Prev Next

​​​Description

Rounds the first argument to the number of decimal places specified in the second argument.

Syntax

ROUND(Number [, Number of Digits])

Arguments

Argument

Type

Dimensions

Description

Number

(required)

Number

Any Dimensions

Number to round.

Number of Digits

(optional)

Integer or Metric

No Dimension or Dimensions of argument Number

Number of decimal places to round to.

By default, the argument Number is rounded to the nearest integer value.

Up to 14 decimal places are permitted, whether specified as an integer or through a Metric.

Returns

Type

Dimensions

Number

Dimensions of argument Number

BLANK if Number of Digits is negative or over 14.

Examples

Formula

Result

Description

ROUND(2.19, 1)

2.2

The nearest number from 2.19 with 1 digit is 2.2.

ROUND(2.11, 1)

2.1

The nearest number from 2.11 with 1 digit is 2.1.

ROUND(2.99, 1)

3.0

The nearest number from 2.99 with 1 digit is 3.0.

ROUND(2.99, 2)

2.99

The nearest number from 2.99 with 2 digits is 2.99.

ROUND(2.99)

3

The nearest number from 2.99 with no digits is 3.

ROUND(2.365, 1)

2.4

The nearest number from 2.365 with 1 digit is 2.4.

ROUND(1.11, -1)

BLANK

The Number of Digits, -1, is invalid.

ROUND(1.1122334455667788,15)

BLANK

The Number of Digits, 15, is invalid.

See also

Excel: ROUND

Related articles: ROUNDUP, ROUNDDOWN

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!