One or the other not both

HOW TO SELECT ONE OR THE OTHER NOT BOTH

If you want to SELECT ONE OR THE OTHER BUT NOT BOTH of two items, the XOR function can be used. In the example below, Cell D7 is worked out with the basic formula below.

=XOR(B7="x",C7="x")

The XOR function operates by returning as TRUE when either FOOTBALL or GOLF contains an “X.” Only one criterion is permitted to be fulfilled.

The function returns as FALSE when both FOOTBALL and GOLF contains an “X” and when FOOTBALL and GOLF contains a different alphabet as shown in the example below.

SELECT ONE OR THE OTHER NOT BOTH

Step 1

  • Input your data

Figure 1- How to Select One or the Other NOT Both

Step 2

  • Click on Cell D7
  • Type this. =XOR(B7="x",C7="x")
  • What you have should be similar to figure 2

Figure 2- How to Select One or the Other Not  Both

Step 3

  • Click on the ENTER button
  • Your result should be as shown in figure 3 below

Figure 3- How to Select One or the Other Not Both

To get the result for the other cells, simply change B7 and C7 as shown on the formula to the Cells under Football and Golf respectively.

You can also use the drop-down feature by clicking on CELL D7 and drag down.

Figure 4- How to Select One or the Other Not Both

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar