𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

+----------+--------+
| Employee | Sales  |
+----------+--------+
| John     | 12,000 |
| Sarah    | 18,000 |
| Mike     | 15,000 |
| David    | 20,000 |
| Alice    | 10,000 |
+----------+--------+

How would you return "High Performer" if sales are greater than or equal to 18,000, "Average Performer" if sales are between 12,000 and 17,999, otherwise return "Low Performer"?

𝗠𝗲: Challenge accepted! 💪

=IFS(
C2>=18000,"High Performer",
C2>=12000,"Average Performer",
TRUE,"Low Performer"
)

💡 Explanation:
The IFS() function checks multiple conditions in sequence and returns the result for the first condition that evaluates to TRUE.

• If sales are 18,000 or more, it returns "High Performer".
• If sales are 12,000 or more, it returns "Average Performer".
• Otherwise, it returns "Low Performer".

This challenge tests your understanding of:
✅ IFS()
✅ Logical Functions
✅ Multiple Conditions
✅ Data Categorization

🎯 Expected Output Example

Employee: John
Sales: 12,000
Performance: Average Performer

Employee: Sarah
Sales: 18,000
Performance: High Performer

Employee: Mike
Sales: 15,000
Performance: Average Performer

Employee: David
Sales: 20,000
Performance: High Performer

Employee: Alice
Sales: 10,000
Performance: Low Performer

🚀 Bonus (Compatible with Older Excel Versions)

=IF(C2>=18000,
"High Performer",
IF(C2>=12000,
"Average Performer",
"Low Performer"))

Nested IF() functions provide the same result and work in Excel versions that don't support IFS().

🚀 Tip for Excel Job Seekers:
Logical functions are heavily used in reporting and dashboards. Make sure you're comfortable with:

• IF()
• IFS()
• AND()
• OR()
• IFERROR()

❤️ React with ❤️ for more Excel interview challenges!