Logic & conditional functions

Intermediate 2 hr 40 min 14 exercises

Practice IF, nested IF, IFS, and multi-condition decision logic used in real business spreadsheets.

What you'll learn

Use IF to return text labels, numeric outputs, or branch on a comparison
Express multi-condition rules in a single formula by combining IF with AND, OR, and NOT
Build nested IF formulas for tiered grades, commission bands, and threshold buckets
Pick the right function for multi-branch logic — nested IF vs. IFS vs. SWITCH
Catch and replace errors like #N/A or #DIV/0 using IFERROR and IF+ISERROR

Functions you'll practice

AND IF IFERROR IFS ISERROR NOT OR SWITCH

Exercises in this track

0 of 14 completed 0%

1

Pass or fail with IF

Beginner

Use the IF function to determine whether students passed or failed based on their scores.

2

IF with numeric output

Beginner

Calculate a 10% bonus if sales exceed target, otherwise 0.

3

Simple IF statement

Beginner

Categorize sales as "On target" or "Below target" based on a threshold.

4

Basic AND function

Beginner

Check if a sale meets BOTH minimum quantity AND minimum value thresholds.

5

IF with OR

Intermediate

Flag high-priority orders (either > $10,000 OR customer is "VIP").

6

IF with AND

Intermediate

Approve a loan only if credit score > 700 AND income > $50,000.

7

Flag overdue invoices with IF and NOT

Beginner

Use IF combined with NOT to flag overdue invoices that are not marked as paid.

8

Practicing and, or, and if

Beginner

This one's an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex...

9

Nested IF for grading

Intermediate

Assign letter grades (A, B, C, D, F) based on numerical scores.

10

Nested IF for commission tiers

Intermediate

Calculate sales commission using a 3-tier rate structure.

11

Assign shipping methods with IFS

Intermediate

Assign shipping method based on package weight using IFS.

12

SWITCH for department budget codes

Intermediate

Use SWITCH to translate department codes into full names and budget categories in a quarterly budget review report.

13

Basic IFERROR exercise

Beginner

In this exercise, we're looking at the IFERROR function. This function can be handy when you expect errors to exist, but you want to handle them...

14

Creating an IFNOTERROR function

Beginner

Create an IFNOTERROR-style formula by combining IF with ISERROR.

Where to go next

Pick another track

Browse all learning tracks to find your next focus area.

Browse all tracks