Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • 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

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
 
Replies continue below

Recommended for you

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