XOR Function in Excel
In this blog post we will learn about “XOR” function Excel. This function is categorized as “Logical Function” in Excel. XOR Function Returns “TRUE” output when "Number of TRUE Conditions" provided in expressions are odd and it returns “FALSE” when “Number of TRUE Conditions” are even. How to find XOR Function on Excel Screen: To find XOR function on our excel screen, go to “Formula Tab” & click on “Logical” command, which will appear all the Logical functions available in excel. We can see “XOR function” as highlighted in below image. When we click on “XOR Function” the following window will appear on screen. We can enter the logical conditions in the respective fields. Alternatively we can also find XOR function by pressing “=” key and typing word “XOR” as shown in below image. Syntax of XOR Function: The syntax of XOR function is as below: =XOR( logical1 ,[logical2],…) Arguments of XOR Function: XOR function have following arguments: Logical1: We can provide 1st cond...