📊 Excel Basics #15 – IF() Function

The "IF()" function is one of the most powerful and widely used functions in Excel. It allows Excel to make decisions based on a condition.

📌 What is the IF() Function?

The "IF()" function checks whether a condition is TRUE or FALSE and returns different results for each case.

Syntax:

=IF(logical_test, value_if_true, value_if_false)

📌 Example 1 – Pass or Fail

Student Marks

Rahul 85

Priya 42

Amit 67

Neha 30

Formula:

=IF(B2>=50,"Pass","Fail")

Result:

• Rahul → Pass

• Priya → Fail

• Amit → Pass

• Neha → Fail

📌 Example 2 – Bonus Eligibility

Employee Sales

Rahul 120000

Priya 85000

Formula:

=IF(B2>=100000,"Bonus","No Bonus")

• Rahul → Bonus

• Priya → No Bonus

📌 Example 3 – Discount Calculation

=IF(A2>=5000,A2*10%,0)

If the purchase amount is ₹5,000 or more, the customer receives a 10% discount; otherwise, the discount is ₹0.

📌 Nested IF()

You can use multiple "IF()" functions to test several conditions.

=IF(B2>=90,"A",IF(B2>=75,"B",IF(B2>=50,"C","Fail")))

• 90 or above → A

• 75–89 → B

• 50–74 → C

• Below 50 → Fail

📌 Real-World Uses

• Calculate pass/fail status.

• Determine bonus eligibility.

• Assign grades.

• Check stock availability.

• Flag overdue payments.

• Categorize sales performance.

📌 Common Mistakes

• Missing commas between arguments.

• Forgetting quotation marks around text values.

• Using too many nested "IF()" functions, making formulas difficult to maintain.

✅ Best Practices

• Keep "IF()" formulas simple whenever possible.

• Use descriptive text like "Pass" or "Approved" instead of numbers when appropriate.

• For multiple conditions, consider using "IFS()" or "SWITCH()" (available in newer versions of Excel).

• Test your formula with different inputs to ensure it works correctly.

The "IF()" function is the foundation of decision-making in Excel and is used extensively in dashboards, financial models, and business reports.

Double Tap ❤️ For More