next up previous contents index
Next: NETWORKDAYS Up: A. Function Reference Previous: NORMSINV   Contents   Index


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

Excel function: N/A


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