next up previous contents index
Next: INTERP2D Up: A. Function Reference Previous: INIT   Contents   Index


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.)


next up previous contents index
Next: INTERP2D Up: A. Function Reference Previous: INIT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003