title: How do I perform a XOR calculation of two binary numbers in excel 2007
body: <p>I wanted to perform a XOR calculation of two Binary numbers for example: on Sheet 1 </p>
  
  <pre><code>Range A1 = 10101010
  Range A2 = 11100010
  </code></pre>
  
  <p>Now I need to perform XOR of A1, A2 result in A3. I tried different formula's two perform XOR calculations like: <code>A1^A2, (BITXOR (A1, A2))</code> but unfortunately it didn't worked I think because I am using excel 2007 "XOR" doesn't support.</p>
  
  <p>I'm expecting a result of <code>1001000</code>.</p>