Formula Engine Reference Guide
 

 

Back to Class Index

 

NOR(argumentlist)

Description
This function returns 0 if any argument is 1; 1 if all arguments are 0; otherwise -1 (unknown).
 
Parameters
argumentlist

Any combination of numbers, cells, or ranges
 
Example
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