Manuals/calci/FLOOR

Syntax

Remarks

Examples

''''''' ''''

Description

FLOOR

FLOOR (N, Signi)

Where N is the numeric value and Signi is the multiple to round up.

· FLOOR returns an error value when argument is nonnumeric or N and Signi have different signs.

· If the number is an exact multiple of significance, no rounding will occur.

.

Floor rounds the numbers down to the nearest multiple of significance.

Lets see an example in (Column1, Row 1)

FLOOR

FLOOR (C1R1, C2R1))'

That is FLOOR (3.5, 2) is 2