Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 10, 2023

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 seems not working..

Thanks in Advance,

Br,

Anupam

 

Formulas and Functions

6 Replies

    • anupambit1797's avatar
      anupambit1797
      Iron Contributor
      Mar 10, 2023
      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 Even
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Mar 10, 2023

        anupambit1797 

        Sorry, 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:

         

         

         

         

         

Resources