XOR Function in Excel – Exclusive OR – Tutorial and Download

Can I use Exclusive OR function XOR?

This is a new function is Excel 2013.  So if you are on an older version, you are out of luck.  I tried to pull up the attached spreadsheet that has a Mac version of Excel 2010, and I received the dreaded #NAME? error.

In the video, Oz du Soleil mentions that most explanations of this functions are programming examples. So he offers this explanation of XOR.  The example reminds me of College/University, where different combinations of prerequisites can be met to satisfy the requirement.

XOR’s options

2015-02-21_15-42-29

 The Setup

The scenario is the attached spreadsheet and video is where a teacher must agree to teach EITHER:

  • a minimum of 4 classes in one section or
  • a minimum of 2 classes in the yellow section, NOT BOTH
    2015-02-21_15-47-01

BONUS Download

Rick Grantham
Follow Me

Tags


You may also like

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free 24 Excel Tips Guide

    Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'

    A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!

    >