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


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

Excel function: N/A


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