IF Formula का सही उपयोग (Excel/Google Sheets में) | How do you use the IF formula in Excel? | How to use if with 2 conditions in Excel? | How to use 4 if condition in Excel? | How to write ifs formula in Excel?

 IF Formula का सही उपयोग (Excel/Google Sheets में) | How do you use the IF formula in Excel?

📌 Introduction

The IF Formula is one of the most powerful and commonly used logical functions in Excel and Google Sheets. It helps you make decisions based on conditions, automating tasks like:
✔️ Checking pass/fail status
✔️ Calculating discounts
✔️ Evaluating employee performance
✔️ Managing business rules

In this blog, we’ll cover:
✅ Basic IF Formula Structure
✅ Nested IF for Multiple Conditions
✅ IF + AND/OR for Complex Logic
✅ Real-Life Examples

Plus, visual examples for better understanding!

📌 Basic IF Formula Structure

The IF function follows this syntax:

=IF(condition, value_if_true, value_if_false)

Example 1: Pass/Fail Check

Suppose Column A contains student marks. Passing marks = 35+.

=IF(A2>=35, "Pass", "Fail")

Result:

• If marks ≥ 35 → "Pass"

• If marks < 35 → "Fail"

📌 Nested IF: Handling Multiple Conditions

      Need to check multiple conditions? Use Nested IF.

Example 2: Grading System

80+ → "A Grade"
60+ → "B Grade"
35+ → "C Grade"
Below 35 → "Fail"

          =IF(A2>=80, "A Grade", IF(A2>=60, "B Grade", IF(A2>=35, "C Grade", "Fail"))) 

📌 IF + AND / OR: Advanced Conditions

1. AND Function (All Conditions Must Be True)

If a student must pass both Math & Science (≥35 marks each):

=IF(AND(B2>=35, C2>=35), "Pass", "Fail")

2. OR Function (Any One Condition Should Be True)

If a student passes if any one subject has ≥35 marks:

=IF(OR(B2>=35, C2>=35), "Pass", "Fail")

Comparison:

AND Formula	OR Formula
Both Subjects ≥35	Any One Subject ≥35

📌 Real-Life IF Formula Examples

1. Sales Discount (10% if Purchase > ₹5000)

=IF(B2>5000, B2*0.9, B2)

2. Employee Bonus (₹5000 if Rating > 8)

=IF(C2>8, 5000, 0)

3. Holiday Check (Sunday = Holiday)

=IF(B2="Sunday", "Holiday", "Working Day")

📌 Frequently Asked Questions (FAQs)

1. Can IF Formula check text values?

Yes! Example:

=IF(A2="Yes", "Approved", "Rejected")

2. How to avoid too many nested IFs?

Use IFS (Excel 2019+) or VLOOKUP for complex conditions.

3. How to fix IF Formula errors?

• #VALUE! → Check for mixed text/number conditions.

• #NAME? → Verify spelling (IF, AND, OR).

📌 Conclusion

The IF Formula is a must-know tool for Excel/Google Sheets users. With it, you can:
✔️ Automate pass/fail checks
✔️ Apply discounts and bonuses
✔️ Manage business rules efficiently

Found this useful? Share with others!

Next Topic: Mastering VLOOKUP Formula (Coming Soon!)

---

📸 Suggested Images for This Blog:

1. Basic IF Formula Example (Pass/Fail Table)

2. Nested IF Grading System (Color-Coded Grades)

3. AND vs OR Comparison (Two Columns Example)

4. Real-Life Uses (Discount, Bonus, Holiday Check)

(Tip: Use Excel screenshots or design tools like Canva for visuals.)

Got a specific IF Formula use case? Let us know in the comments! 😊