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.
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
- Input your data
Figure 1- How to Select One or the Other NOT Both
- Click on Cell D7
- Type this.
- What you have should be similar to figure 2
Figure 2- How to Select One or the Other Not Both
- 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