ROUNDDOWN

Rounds the amount down (towards 0 if negative) to the number of digits specified.

Formula Syntax

ROUNDDOWN(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

ROUNDDOWN(5.454, 1) equals 5.4

ROUNDDOWN(-5.454, 1) equals -5.4

ROUNDDOWN(151, -2) equals 100

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com