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

You have the following data:

Employee ID | Employee Name | Sales
--- | --- | ---
101 | John | 12,000
102 | Sarah | 18,000
103 | Mike | 15,000
104 | David | 20,000

How would you return "Yes" if an employee's sales are greater than or equal to 15,000, otherwise return "No"?

𝗠𝗲: Challenge accepted! 💪

=IF(C2>=15000,"Yes","No")

💡 Explanation:

The IF() function checks whether a condition is true or false.

C2>=15000 checks if the sales value is at least 15,000.

If the condition is TRUE, Excel returns "Yes".

If the condition is FALSE, Excel returns "No".

🎯 Expected Output Example

+----------+--------+----------+
| Employee | Sales  | Eligible |
+----------+--------+----------+
| John     | 12,000 | No       |
| Sarah    | 18,000 | Yes      |
| Mike     | 15,000 | Yes      |
| David    | 20,000 | Yes      |
+----------+--------+----------+

🚀 Bonus (Using Nested IF)

=IF(C2>=20000,"Excellent", IF(C2>=15000,"Good","Needs Improvement"))

This formula categorizes employees into three performance levels:

• Excellent → Sales ≥ 20,000
• Good → Sales ≥ 15,000
• Needs Improvement → Sales < 15,000

🚀 The IF() function is one of the most frequently asked Excel interview topics. Once you're comfortable with it, practice:

IFS()

IFERROR()

AND()

OR()

SWITCH()

These logical functions are widely used in reports, dashboards, and business decision-making.

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