Nested IF functions 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 of each store based on monthly sales figures.

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

🎯 Deliverable: Create a new column that uses nested IF functions to assign a performance category: 'Low' for sales under 5000, 'Medium' for sales between 5000 and 10000, and 'High' for sales above 10000.

Sample Data

Store	Monthly Sales
Store A	4500
Store B	7200
Store C	11000
Store D	3000
Store E	9800
Store F	15000
Store G	6700
Store H	4000

1

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

Expected Result

A new empty column labeled 'Performance Category' appears next to 'Monthly Sales'.

2

Step 2: In the first cell under 'Performance Category' (assume C2), enter the nested IF formula to categorize sales.

=IF(B2<5000, "Low", IF(B2<=10000, "Medium", "High"))

Expected Result

For Store A with sales 4500, the formula returns 'Low'.

3

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

Drag the fill handle from C2 down to C9.

Expected Result

Each store's sales is categorized correctly: Store B 'Medium', Store C 'High', Store D 'Low', Store E 'Medium', Store F 'High', Store G 'Medium', Store H 'Low'.

Final Result

Store    Monthly Sales    Performance Category
---------------------------------------------
Store A  4500             Low
Store B  7200             Medium
Store C  11000            High
Store D  3000             Low
Store E  9800             Medium
Store F  15000            High
Store G  6700             Medium
Store H  4000             Low

✓Stores with sales below 5000 are categorized as Low performance.

✓Stores with sales between 5000 and 10000 are Medium performers.

✓Stores with sales above 10000 are High performers.

Bonus Challenge

Add a new category 'Very High' for sales above 15000 using nested IF functions.

Show Hint

Use an additional IF inside the last 'High' category to check if sales are greater than 15000.