Exclusive "OR" formula

[Len Silva]

I know this must be simple but I am having head problems here.

What I need is: if A is TRUE or if B is TRUE =TRUE but not if both A and B are true or if both A and B are false.

Thanks,

Len Silva

[Jonmo1]

Try

=A+B=1

[TMS]

So, if A = B, then the answer is FALSE, because they are both either TRUE or FALSE. Conversely, if one is TRUE, the other must be FALSE and the outcome is TRUE.

Then

Please Login or Register  to view this content.

Regards, TMS

[Pete_UK]

Another one:

=A<>B

or if you want to use cell references:

=A1<>B1

Hope this helps.

Pete

[Jonmo1]

Note to OP.

If you ask your question using Psudo Code, you can expect to get responses also in Psudo Code.

It might help to provide a more detailed/specific explaination of your issue.

[Len Silva]

"Headslap" Thank you folks. I had been screwing around if if's and's and or's until I was way over-thinking it.

[TMS]

So, options to date:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards, TMS