next up previous contents index
Next: ANNOTATE Up: A. Function Reference Previous: ALARM   Contents   Index


AND, XLAND

Syntax: AND(argumentlist)
  XLAND(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

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

XLAND returns 1 if all arguments are non-zero, and 0 if any argument is zero.

Examples:

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

AND(A1, B1) = 1

AND(A1..E1) = 0

XLAND(A1..E1) = 0

AND(A1..A2) = -1

XLAND(A1..A2) = 1

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

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


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