FLOOR, XLFLOOR

Syntax: |
FLOOR(X[, S]) |

XLFLOOR(X, S) |

*X* = a numeric value

*S* = significance parameter

**FLOOR** returns the largest integer that is less than
or equal to *X*. If the optional significance parameter
*S* is specified, **FLOOR** returns *X* rounded down
to the nearest multiple of *S*. When *S* is omitted
it is assumed to be 1. The mathematical formula
is given by:

**XLFLOOR** is designed to be compatible with the Excel
**FLOOR** function. It is functionally equivalent to
SpreadScript's native **FLOOR**, except that the parameter
*S* is required.

If both *X* and *S* are specified, they must have the
same sign, or an error is generated. *S* should not be
set to 0, or an error will result.

**Examples:**

**FLOOR**(5.5) = 5

**FLOOR**(3.14159, 0.01) = 3.14

**FLOOR**(E3) = -10, where E3 = -9.99

**XLFLOOR**(-9.99, 1) = Error!

**XLFLOOR**(-9.99, -1) = -9

**FLOOR**(-9.99, -1) = -9
(in Excel compatibility mode)

**FLOOR**(C17) = 1, where C17 = 1

**Excel function:** **XLFLOOR** is compatible with Excel's **FLOOR**
(In Excel compatibility mode, the ``XL'' prefix is not used.)

Grey Trout Software

02 March 2003