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!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

XOR in Excel

  • Thread starter Thread starter -
  • Start date Start date
Status
Not open for further replies.

Guest
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top