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

Grey Trout Software

02 March 2003