📊 Excel Formulas — Part 2

This part focuses on logical formulas — formulas that help Excel make decisions based on conditions.

1️⃣ IF

Returns one value when a condition is TRUE and another when it is FALSE.

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

Example: If marks are 50 or more → Pass, otherwise → Fail.

2️⃣ IFS

Checks multiple conditions without using deeply nested IFs.

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

Example:

90+ → A

75–89 → B

50–74 → C

Below 50 → Fail

3️⃣ AND

Returns TRUE only when all conditions are TRUE.

=AND(B2>=50,C2>=75)

Example: Check whether a student scored at least 50 in one subject and 75 in another.

4️⃣ OR

Returns TRUE when at least one condition is TRUE.

=OR(B2>=90,C2>=90)

Example: Check whether a student scored 90 or more in either subject.

5️⃣ NOT

Reverses a logical result.

=NOT(B2="Completed")

If B2 contains Completed, the result is FALSE.

🔥 Combine Logical Functions

You can combine them to create more useful formulas.

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

This checks whether the student passed both subjects.

Another example:

=IF(OR(B2="Yes",C2="Yes"),"Eligible","Not Eligible")

💡 Quick Practice

Student Marks 1 Marks 2

Rahul 75 82

Priya 45 90

Amit 60 40

Neha 95 88

Try creating formulas to:

1. Check whether both marks are ≥ 50 → AND

2. Check whether either mark is ≥ 90 → OR

3. Return Pass/Fail → IF

4. Categorize students based on marks → IFS

Double Tap ❤️ For Part-3