This formula returns TRUE when either coffee or tea have an “x”. It returns FALSE if both coffee or team has an “x”, or if neither coffee or team has an “x”. With two logical criteria, XOR has a particular behavior, summarized in the table below: At each row in column E, XOR evaluates values in column C and D and returns a TRUE or FALSE result. This behavior is sometimes referred to as “exclusive OR”, meaning only one result can be true. Note: with more than two criteria, XOR behavior changes, as explained on the XOR function page.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.