Forum Discussion
XOR in Text
Dear Experts, Which function shall I use to do the XOR between two strings? If , I would have 0/1 then Bitxor does the job, but with "text" not sure how to use.. I tried XOR but ...
anupambit1797 Perhaps this?
- Thanks Riny, I want something like, so in output not the logical value but the values from column A&B only:-
Even Even Even
Even Odd Odd
Odd Even Odd
Odd Odd EvenSorry, but I don't follow. XOR does work with the TRUE and FALSE logic and you can make it show as 1 and 0, for instance by using =--XOR(xxx, xxx).
That's why it works with numbers. 0 is seen as FALSE and any other number, so not only the number 1, is seen as TRUE.
You could mimic that behavior for texts with a simple IF formula, as follows:
- Thanks Riny for your response, yes this helps !!
