Question: how to create xor formula in excel?
Answer: To use the XOR function, simply type =XOR and Excel will prompt you to enter logical statements. You can also just feed it an array of true/false values. For example in the video, the reference range that we want is (A2=A$2:A2).