next up previous contents index
Next: MONTH Up: A. Function Reference Previous: MODE   Contents   Index


MODULUS, XLMOD

Syntax: MODULUS(X, Y)
  XLMOD(X, Y)

X = a numeric value
Y = a numeric value

MODULUS returns the modulus of X/Y. XLMOD is a synonym for MODULUS.

Examples:

MODULUS(8, 4) = 0

MODULUS(D2, F3) = 12, where D2 = 100 and F3 = 44

MODULUS(F5, A1) = Error - divide by zero, where F5 = 98.6 and A1 = 0

MODULUS(-14, 3) = 1

MOD(-14, 3) = 1 (in Excel compatibility mode)

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


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