FLOOR

Calculates the amount rounded down to the next-lowest integer (next-highest integer if negative).

Formula Syntax

FLOOR(Amount, Significance)

Amount: number being rounded.

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

Examples

FLOOR(5.4) equals 5

FLOOR(-5.4) equals -6

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