XOR as a function Home Board Archive Index Excel Formulas XOR as a function Posted by russ on January 18, 2002 9:57 AM Where is it OR How can I get it as a function? Posted by Aladin Akyurek on January 18, 2002 1:18 PM There isn't one. Maybe some would want to write up in VBA. However, what follows might be of some use to you: Lets take the following sample: {0,0,1,1; 0,1,0,1} which is in A1:D2. In A4 enter: =OR(AND(A1,NOT(A2)),AND(A2,NOT(A1))) and copy across. Aladin