SWITCH, XOR, IFNA, EXACT — Excel lesson

Task 1 of 3

Lesson theory

SWITCH(value, option1, result1, …, [default]) replaces a long chain of IFs when you compare against exact values;
EXACT(text1, text2) compares case-sensitively. The usual =A2=B2 ignores case;
IFNA(value, fallback) works like IFERROR but catches only #N/A. Other errors stay visible, so you will not miss them;
XOR(cond1, cond2) is TRUE when exactly one condition is true (for two conditions).

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page

Practice is part of Pro

The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.