All lessons
LogicintermediatePro

IFS & SWITCH

Test several conditions at once without nesting nested IFs — IFS checks a list of conditions, SWITCH matches a value against a list of options.

IFS & SWITCH is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans