Administration and Executive AssistantTier 255 minintermediate

IF, IFS, and SWITCH

Make decisions in formulas with multiple conditions.

What you will learn

• Use nested IF for simple decisions
• Use IFS for cleaner multiple conditions
• Use SWITCH for exact matches
• Understand logical operators (AND, OR, NOT)

Excel skills

IF, IFS, SWITCH, AND, OR, NOT · Conditional Logic

The task

Eighteen leave requests need routing: 1-2 days goes to the direct Manager, 3-5 days needs Senior Manager sign-off, 6 or more days goes to HR. I need the Approval Level worked out automatically from the number of days requested.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free