Does Excel have an Exclusive Or Function

[bbbb1234]

I hope most those who might answer this know what an exclusive OR is but just in case, here is a simple example...

A1 can be True or False
B1 can be True or False
C1 contains the exclusive OR function of A1/B1

So if...
A1=False, B1=False, then C1 = False
A1=False, B1=True, then C1 = True
A1=True, B1=False, then C1 = True
A1=True, B1=True, then C1 = False

Any ideas for the function that goes in C1? I can't find a built in function for this.

 

[mortgageman]

Formula for C1: =NOT(a1=b1)

(copied down)

Gene Klein

 

[Tazguy37]

You're right, Excel doesn't have a built-in XOR function, but VBA does, which makes it much easier to make your own. In a standalone module (preferably in an add-in, so you can use it whenever you want, you can enter this function:

Public Function ExOr(arg1 As Variant, arg2 As Variant)

    ExOr = arg1 Xor arg2

End Function

That way, if you want to hardcode one of the numbers instead of using a range, you can.

Hope that helps!

 

[hansvdbraak]

doesn't seem right: not (a=b) is a so called NAND

exor is also 'easily' to implement:

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


Hans

 

[Laurent C]

I would have gone for
=AND(
OR(A1,B1),
NOT(
AND(A1,B1)
)
)

 

[hansvdbraak]

is indeed shorter.

I read A1=B1 as an AND but it is meant as comparision and thats why the above first 'algorithm' is correct!

 

[Colin Legg]

Another way:

=(A1+B1)=1