NOR(<List>)

 

Description

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

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

Given:

 

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

 

NOR(C1, D1) = 1

 

NOR(A1:E1) = 0

 

NOR(A1:A2) = -1