ROUNDUP

Rounds the amount up (away from 0 if negative) to the number of digits specified.

Formula Syntax

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

ROUNDUP(5.454, 1) equals 5.5

ROUNDUP(-5.454, 1) equals -5.5

ROUNDUP(149, -2) equals 200

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com