ROUND

Rounds the amount to the number of digits specified.

Formula Syntax

ROUND(Amount, Digits)

Amount: number to be rounded.

Digits: number of digits to which amount should be rounded.

Additional Comments

If the digits value equals 0, rounding is to the nearest integer.

If the digits value is negative, rounding is done to the left of the decimal point.

Examples

ROUND(5.454, 1) equals 5.5

ROUND(-5.454, 1) equals -5.5

ROUND(149, -2) equals 100

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com