Exclusive Or function (Office 2003)

Topic

New Reply

Hello

Is it possible to create an Exclusive Or function in Excel? I’m working on a project that has a requirement to use this function along with a few other logic operators. If Excel will allow me to genrate an XOR then it makes life a little easier, if not I’ll figure it out another way.

Thanks.

Ian

Reply | Quote

Replies

If you want to use a logical XOR function (as opposed to a bitwise XOR function), you can create this custom function in your Personal.xls:

Public Function MyXOR(Arg1 As Variant, Arg2 As Variant) As Variant
MyXOR = CBool(Arg1) Xor CBool(Arg2)
End Function

Use in a formula like this:

=MyXOR(A1,A2)

Note: you cannot name this function XOR since that is already a VBA function.

Reply | Quote

You can try the following:

=AND(OR(A1,B1),NOT(AND(A1,B1)))

Reply | Quote

Another (not quite equivalent) possibility is to combine OR and AND:

=OR(A1,A2)-AND(A1,A2)

Reply | Quote

This also works if the cells are both boolean, though if you have numbers in them it can fail.
=A1A2

Steve

Reply | Quote

Great

Thanks for the help, all methods seem to work fine.

Ian

Reply | Quote