next up previous contents index
Next: XVALUE Up: A Function Reference Previous: XNPV

XOR

 

Syntax: @XOR(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

@XOR returns -1 if any argument is not 0 or 1; otherwise 1 if the total number of arguments with the value 1 is odd; 0 if the total number of arguments with the value 1 is even. Text and blank cells are ignored.

Examples:

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

@XOR(A1, B1) = 0

@XOR(A1..E1) = 1

@XOR(A1..A2) = -1


next up previous contents index
Next: XVALUE Up: A Function Reference Previous: XNPV

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