INT, XLINT

Syntax: |
INT(X) |

XLINT(X) |

*X* = a numeric value

**INT** returns the integer portion of *X*, rounded towards zero
for both positive and negative values of *X*.
**XLINT** returns the integer portion of *X*, rounded towards
zero for positive values of *X*, and away from zero for
negative values of *X*.

**Examples:**

**INT**(232.45566) = 232

**INT**(J20) = -10, where J20 = -10.3

**XLINT**(J20) = -11, where J20 = -10.3

**XLINT**(**PI()**) = 3

**INT**(**PI()**) = 3
(in Excel compatibility mode)

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

Grey Trout Software

02 March 2003