CEILING

Calculates the amount rounded up to the next multiple of significance.

Formula Syntax

CEILING(Amount, Significance)

Amount: number being rounded.

Significance (optional): multiple to which rounding is to be calculated (default value equals 1).

Examples

CEILING(5.4, 2) equals 6

CEILING(-5.4, 2) equals -4

Comments

If significance equals zero or is negative when the amount is positive, 0 is returned.

If the amount is an exact multiple of significance, no rounding occurs.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com