IF with OR
IntermediateImagine you're part of a sales team that needs to quickly spot orders that should get extra attention.
A common pattern is: if any of several conditions is true, label the row as high priority. In Excel, you do that by putting an OR test inside an IF.
What you need to do:
- In F2, write a formula that returns "High" when either of these is true:
- The Order total ($) is greater than 10,000
- The Tier is "VIP"
- Otherwise, return "Standard".
- Fill the formula down through F11.
Need some help?
Hint 1
Build the OR test first: one comparison for the order total and one text comparison for the tier.
Hint 2
Your two logical tests should look like: Order total > 10000 and Tier = "VIP" (using the same row).
Hint 3
Wrap OR inside IF so the result is "High" or "Standard", then fill the formula down the column.
Answer
Exercise
IF with OR
IntermediateImagine you're part of a sales team that needs to quickly spot orders that should get extra attention.
A common pattern is: if any of several conditions is true, label the row as high priority. In Excel, you do that by putting an OR test inside an IF.
What you need to do:
- In F2, write a formula that returns "High" when either of these is true:
- The Order total ($) is greater than 10,000
- The Tier is "VIP"
- Otherwise, return "Standard".
- Fill the formula down through F11.
Need some help?
Hint 1
Build the OR test first: one comparison for the order total and one text comparison for the tier.
Hint 2
Your two logical tests should look like: Order total > 10000 and Tier = "VIP" (using the same row).
Hint 3
Wrap OR inside IF so the result is "High" or "Standard", then fill the formula down the column.