next up previous contents index
Next: PERCENTILE Up: A. Function Reference Previous: ODDLYIELD   Contents   Index


OR, XLOR

Syntax: OR(argumentlist)
  XLOR(argumentlist)

argumentlist = any combination of numbers, cells or ranges

OR returns 1 if any argument is 1; 0 if all arguments are 0; otherwise -1 (unknown).

XLOR returns 1 if any argument is non-zero, and 0 if all arguments are 0. XLOR is compatible with Excel's OR function.

Examples:

A1 = 1, B1 = 1, C1 = 0, D1 = 0, E1 = 1 and A2 = 24

OR(C1, D1) = 0

OR(A1..E1) = 1

XLOR(A1..E1) = 1

OR(A1..A2) = -1

XLOR(A1..A2) = 1

OR(A1:A2) = 1 (in Excel compatibility mode)

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


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