NAND(<List>)

 

Description

This function returns 0 if all arguments are 1; 1 if any argument is 0; -1 otherwise.

 

Parameters

 

<List>

Any combination or numbers, cells, or ranges.

 

Examples

 

Given:

 

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