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

AND

 

Syntax: @AND(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).

Examples:

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

@AND(A1, B1) = 1

@AND(A1..E1) = 0

@AND(A1..A2) = -1


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999