IF function in Google Sheets - 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' if the sale amount is $500 or more, and 'Low' if it is less than $500.

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

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

Sample Data

Sale ID	Sale Amount
101	450
102	700
103	300
104	520
105	480
106	600
107	200
108	750

1

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

Expected Result

A new column 'Sale Level' is added next to 'Sale Amount'.

2

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

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

Expected Result

For sale amount 450, the formula returns 'Low'.

3

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

Drag the fill handle from C2 down to C9.

Expected Result

Each sale is labeled 'High' if sale amount is 500 or more, otherwise 'Low'.

Final Result

Sale ID | Sale Amount | Sale Level
--------|-------------|-----------
101     | 450         | Low
102     | 700         | High
103     | 300         | Low
104     | 520         | High
105     | 480         | Low
106     | 600         | High
107     | 200         | Low
108     | 750         | High

✓Sales with amounts 500 or more are marked as 'High'.

✓Sales below 500 are marked as 'Low'.

✓This helps quickly identify big sales.

Bonus Challenge

Modify the IF formula to also label sales as 'Medium' if the sale amount is between 400 and 499, 'High' if 500 or more, and 'Low' if less than 400.

Show Hint

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