IFS function in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants you to categorize sales performance for each store based on monthly sales numbers.

📊 Data: You have a table with store names and their monthly sales amounts.

🎯 Deliverable: Create a new column that uses the IFS function to assign performance categories: 'Excellent' for sales above 10000, 'Good' for sales between 7000 and 10000, 'Average' for sales between 4000 and 7000, and 'Poor' for sales below 4000.

Sample Data

Store	Monthly Sales
Store A	12000
Store B	8500
Store C	6700
Store D	3900
Store E	15000
Store F	7200
Store G	3000
Store H	9800

1

Step 1: Insert a new column next to 'Monthly Sales' and label it 'Performance Category'.

Expected Result

A new column ready to hold performance categories.

2

Step 2: In the first cell under 'Performance Category' (e.g., C2), enter the IFS formula to categorize sales.

=IFS(B2>10000, "Excellent", B2>7000, "Good", B2>4000, "Average", B2<=4000, "Poor")

Expected Result

For Store A with 12000 sales, the formula returns 'Excellent'.

3

Step 3: Copy the formula down the entire 'Performance Category' column for all stores.

Drag the fill handle from C2 down to C9.

Expected Result

Each store has a performance category assigned based on its sales.

Final Result

Store    Monthly Sales    Performance Category
---------------------------------------------
Store A  12000           Excellent
Store B  8500            Good
Store C  6700            Average
Store D  3900            Poor
Store E  15000           Excellent
Store F  7200            Good
Store G  3000            Poor
Store H  9800            Good

✓Stores with sales above 10000 are marked as Excellent.

✓Stores with sales between 7000 and 10000 are marked as Good.

✓Stores with sales between 4000 and 7000 are marked as Average.

✓Stores with sales below 4000 are marked as Poor.

Bonus Challenge

Add a new category 'Outstanding' for sales above 14000 and update the IFS formula accordingly.

Show Hint

Add the condition B2>14000, "Outstanding" as the first condition in the IFS formula.