next up previous contents index
Next: NETWORKDAYS Up: A Function Reference Previous: N

NAND

 

Syntax: @NAND(argumentlist)

argumentlist = any combination or numbers, cell, or ranges

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

Examples:

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

@NAND(A1, B1) = 0

@NAND(A1..E1) = 1

@NAND(A1..A2) = -1


next up previous contents index
Next: NETWORKDAYS Up: A Function Reference Previous: N

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