IF function in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a retail store.

📋 Request: Your manager wants you to mark each sale as 'High' or 'Low' based on the sale amount. Sales above $500 are 'High', and $500 or below are 'Low'.

📊 Data: You have a list of sales transactions with the sale ID and sale amount.

🎯 Deliverable: Create a new column that uses the IF function to label each sale as 'High' or 'Low'.

Sample Data

Sale ID	Sale Amount
101	450
102	700
103	300
104	800
105	500
106	650
107	200
108	550

1

Step 1: Insert a new column next to 'Sale Amount' and name it 'Sale Category'.

Expected Result

A new column labeled 'Sale Category' is added.

2

Step 2: In the first cell under 'Sale Category' (assuming C2), enter the IF formula to check if the sale amount is greater than 500.

=IF(B2>500, "High", "Low")

Expected Result

For Sale Amount 450, the result is 'Low'.

3

Step 3: Copy the formula down the 'Sale Category' column for all sales.

Drag the fill handle from C2 down to C9.

Expected Result

All sales are labeled 'High' or 'Low' correctly based on their amounts.

Final Result

Sale ID | Sale Amount | Sale Category
--------|-------------|--------------
101     | 450         | Low          
102     | 700         | High         
103     | 300         | Low          
104     | 800         | High         
105     | 500         | Low          
106     | 650         | High         
107     | 200         | Low          
108     | 550         | High         

✓Sales above $500 are correctly marked as 'High'.

✓Sales $500 or below are correctly marked as 'Low'.

✓The IF function helps quickly categorize sales based on conditions.

Bonus Challenge

Modify the formula to also label sales exactly $500 as 'Medium' instead of 'Low'.

Show Hint

Use nested IF functions: =IF(B2>500, "High", IF(B2=500, "Medium", "Low"))