Excel XOR Function

XOR Function

TheXOR function is a premade function in Excel, which returnsTRUE orFALSE based on two or moreconditions.

It is typed=XOR:

Theconditions are referred to as[logical1],[logical2], and so on.

The conditions can check things like:

• If a number isgreater than another number>
• If a number issmaller than another number<
• If a number or text isequal to something=

For two conditions, you can think of the XOR function as:"either thisor that, butnot both"

Example XOR Function

Check if the Pokemon type is either Fire typeOR has HPless than 60, butnot both:

The function returns "TRUE" or "FALSE".

NameType 1HPEITHER Fire Type OR less than 60 HP BulbasaurGrass45 IvysaurGrass60 VenusaurGrass80 CharmanderFire39 CharmeleonFire58 CharizardFire78 SquirtleWater44 WartortleWater59 BlastoiseWater79

Copy Values

ExampleXOR function, step by step:

1. Select the cellD2
2. Type=XOR
3. Double click theXOR command

4. Specify the first conditionB2="Fire"
5. Type,
6. Specify the second conditionC2<60
7. Hit enter

Since the value in cellB2 is not "Fire" the first condition isFALSE.

Since the value in cellC2 is less than 60 the second condition isTRUE.

For two conditions,only one condition should to beTRUE for the XOR function to returnTRUE.

The function can be repeated with thefilling function for each row to perform the same check for each Pokemon:

Now, each row has a check for Fire Typeor HP less than 60, butnot both:

For example:

• Ivysaur isnot Fire type, but it also does not haveless than 60 defense, so the function returns "FALSE".
• Charmeleonis Fire type, and hasless than 60 defense, so the function returns "FALSE"
• Wartortle isnot Fire type, but hasless than 60 defense, so the function returns "TRUE"

Example XOR Function (with IF)

Combining the XOR function with anIF function lets you checkmultiple conditions for the IF function:

The IF function is typed=IF and has 3 parts:

The XOR function takes the place of thelogical_test condition.

Here, theIF function returns "Yes" or "No".

ExampleXOR function as the condition forIF function, step by step:

1. Select cellC2
2. Type=IF
3. Double click theIF command

4. TypeXOR
5. Double click theXOR command

7. Specify the first conditionB2="Fire"
8. Type,
9. Specify the second conditionC2<60
10. Type),
11. Specify the value"Yes" for when just one condition isTRUE
12. Type,
13. Specify the value"No" for when both areFALSE, orTRUE at the same time
14. Type) and hit enter

The function can be repeated with thefilling function for each row to perform the same check for each Pokemon:

Now, each row has a check for Water Typeor Defense greater than 60, butnot both:

For example:

• Ivysaur isnot Fire type, but it also does not haveless than 60 defense, so the function returns "No".
• Charmeleonis Fire type, and hasless than 60 defense, so the function returns "No"
• Wartortle isnot Fire type, but hasless than 60 defense, so the function returns "Yes"