XOR in Excel

Jan 9, 2002

Hi,
Do someone know if it is possible add the function XOR in Excel DIRECTLY (without the XOR=OR-AND method)?

Thank you,
Guglielmo
090764@tin.it

ivymike · Jan 9, 2002

xor is built into visual basic, so one way to solve the problem would be to write a visual basic function MyXor().

Function MyXor(MyInput1 As Variant, MyInput2 As Variant)

MyXor = MyInput1 Xor MyInput2

End Function

of course, the way I've written it there, it will only accept 2 inputs.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

XOR in Excel

Guest

ivymike

Mechanical

Similar threads

Part and Inventory Search

Sponsor