Excel-AND, OR and NOT with IF Practice Questions with Solutions

Introduction

The AND, OR, and NOT functions become especially useful when an Excel formula needs to check more than one condition. When combined with IF, they can be used for eligibility checks, results, attendance, discounts, approvals, targets, and other practical decisions. In this chapter, you will practice different examples using combinations of Excel-AND, OR, and NOT with IF Practice Questions with Solutions.

Question 1: Check Student Pass Status Using AND

Problem Statement

A student must score 40 or more in both subjects to pass. Use IF and AND to determine whether each student has passed.

Excel Data

Solution

In D2, enter:

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

Copy the formula down.

Expected Output

AND returns TRUE only when all specified conditions are TRUE.

Question 2: Employee Bonus Eligibility Using AND

Problem Statement

An employee is eligible for a bonus if:

• Sales are at least ₹5,00,000
• Customer Rating is at least 4

Use IF with AND.

Excel Data

Solution

In D2, enter:

=IF(AND(B2>=500000,C2>=4),"Eligible","Not Eligible")

Copy down.

Expected Output

Question 3: Free Delivery Using OR

Problem Statement

A store offers free delivery when either of these conditions is met:

• Order amount is at least ₹2,000
• Customer is a Premium member

Use IF and OR.

Excel Data

Solution

In D2, enter:

=IF(OR(B2>=2000,C2="Yes"),"Free Delivery","Delivery Charges")

Copy down.

Expected Output

OR returns TRUE when at least one condition is TRUE.

Question 4: Use NOT to Check Inactive Employees

Problem Statement

An employee should be marked Active when the value in the Status column is not "Inactive".

Use IF and NOT.

Excel Data

Solution

In C2, enter:

=IF(NOT(B2="Inactive"),"Active Employee","Inactive Employee")

Copy down.

Expected Output

NOT reverses a logical result. If the condition is TRUE, NOT makes it FALSE, and vice versa.

Question 5: Scholarship Eligibility Using AND and OR

Problem Statement

A student receives a scholarship if:

• Marks are at least 85, OR
• Marks are at least 75 AND attendance is at least 90%

Use IF, AND, and OR.

Excel Data

Solution

In D2, enter:

=IF(OR(B2>=85,AND(B2>=75,C2>=90%)),"Eligible","Not Eligible")

Copy down.

Expected Output

This example shows how AND can be placed inside OR.

Question 6: Approve a Loan Application Using AND and NOT

Problem Statement

A loan application is approved when:

• Monthly income is at least ₹50,000
• Credit score is at least 700
• Applicant is not marked as "Rejected"

Excel Data

Solution

In E2, enter:

=IF(AND(B2>=50000,C2>=700,NOT(D2="Rejected")),"Approve","Reject")

Copy down.

Expected Output

Question 7: Check Product Restocking Requirement

Problem Statement

A product needs to be restocked when:

• Stock is less than 10, OR
• The product is marked as "Discontinued".

Use IF and OR.

Excel Data

Solution

In D2, enter:

=IF(OR(B2<10,C2="Discontinued"),"Review Stock","No Action")

Copy down.

Expected Output

Question 8: Employee Performance Category Using AND

Problem Statement

Classify employees using these rules:

• Excellent → Sales at least ₹8,00,000 AND rating at least 4.5
• Otherwise → Regular

Excel Data

Solution

In D2, enter:

=IF(AND(B2>=800000,C2>=4.5),"Excellent","Regular")

Copy down.

Expected Output

Question 9: Check Whether a Customer Needs Follow-Up

Problem Statement

A customer needs follow-up when:

• The order status is "Pending", OR
• The payment status is "Failed"

Use IF and OR.

Excel Data

Solution

In D2, enter:

=IF(OR(B2="Pending",C2="Failed"),"Follow Up","No Follow Up")

Copy down.

Expected Output

Question 10: Create a Practical Employee Eligibility Check

Problem Statement

A company wants to identify employees eligible for a training program.

An employee is eligible when:

• Department is IT OR Data Analytics
• Attendance is at least 85%
• Employee is not on probation

Use IF, AND, OR, and NOT in one formula.

Excel Data

Solution

In E2, enter:

=IF(AND(OR(B2="IT",B2="Data Analytics"),C2>=85%,NOT(D2="Probation")),"Eligible","Not Eligible")

Copy the formula down.

Expected Output

This question combines all four functions:

• IF
• AND
• OR
• NOT

It is a useful pattern for more advanced logical formulas.

Key Takeaways

• AND checks whether all conditions are TRUE.
• OR in excel checks whether at least one condition is TRUE.
• NOT reverses a logical result.
• IF in excel can use AND, OR, and NOT to create practical decision-making formulas.
• AND is useful when multiple requirements must be satisfied.
• OR is useful when any one of several conditions can qualify.
• NOT in excel is useful when you need to exclude a particular condition.
• Functions can be nested inside one another.
• AND can be placed inside OR, and NOT can be used inside AND or OR.
• Combining logical functions is useful for eligibility, approvals, attendance, sales targets, inventory and status checks.

FAQs

1. What does AND do in Excel?

AND checks multiple conditions and returns TRUE only when every condition is TRUE.

=AND(A2>=50,B2>=50)

2. What does OR do in Excel?

OR returns TRUE when at least one of its conditions is TRUE.

=OR(A2="IT",A2="HR")

3. What does NOT do in Excel?

NOT reverses a logical result.

=NOT(A2="Inactive")

If A2 contains "Inactive", the result is FALSE.

4. Can AND be used with IF?

Yes. For example:

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

5. Can OR be used with IF?

Yes. For example:

=IF(OR(B2>=80,C2>=90),"Eligible","Not Eligible")

6. Can AND and OR be used together?

Yes. This is useful when a decision contains different groups of conditions.

=IF(OR(B2="IT",AND(B2="HR",C2>=90%)),"Eligible","Not Eligible")

7. Can NOT be combined with AND?

Yes. For example:

=IF(AND(B2>=50,NOT(C2="Rejected")),"Approve","Reject")

8. What is the difference between AND and OR?

AND requires every condition to be TRUE, while OR requires at least one condition to be TRUE.

9. Can I use text conditions with AND and OR in excel?

Yes. You can compare text values such as department, status, category, city, or membership type.

=IF(OR(B2="IT",B2="Finance"),"Allowed","Not Allowed")

10. Why are AND, OR and NOT important in Excel?

They allow formulas to handle multiple conditions instead of checking only one condition. They are especially useful for practical data analysis, eligibility checks, approvals, employee records and business rules.

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Rishabh Kumar