Introduction
The AND function in Excel checks multiple conditions at the same time. It returns TRUE only when all conditions are satisfied. If even one condition is FALSE, the result is FALSE.
For example, a company may offer an employee a bonus only when the employee achieves the required sales target and maintains a good performance score. The AND function makes it easy to check both conditions in a single formula.
What Is the AND Function in Excel?
The AND function is a logical function used to test two or more conditions together.
- If all conditions are TRUE, the result is TRUE.
- If at least one condition is FALSE, the result is FALSE.
AND Function Syntax
=AND(logical1, [logical2], ...)
Arguments:
logical1: The first condition to check.logical2: The second condition (optional)....: Additional conditions you want to test.
Practical Examples of AND Function in Excel
Question 1: Check Student Pass Eligibility
Problem Statement: A school wants to mark students as eligible for passing only when they score at least 40 marks in both Mathematics and English.
Student Data:
| Student Name | Mathematics | English | Result |
|---|---|---|---|
| Rahul | 75 | 65 | |
| Priya | 55 | 35 | |
| Amit | 40 | 45 | |
| Neha | 30 | 80 |
Excel Formula (D2):
=AND(B2>=40,C2>=40)
Expected Result:
| Student Name | Mathematics | English | Result |
|---|---|---|---|
| Rahul | 75 | 65 | TRUE |
| Priya | 55 | 35 | FALSE |
| Amit | 40 | 45 | TRUE |
| Neha | 30 | 80 | FALSE |
Explanation: Excel checks both subject marks. The result is TRUE only when the student scores 40 or more in both subjects.
Concept Covered: Checking multiple numeric conditions.
Question 2: Check Employee Bonus Eligibility
Problem Statement: A company offers a bonus to employees who achieve sales of at least ₹1,00,000 and have a performance score of 80 or above.
Employee Data:
| Employee Name | Monthly Sales | Performance Score | Bonus Eligibility |
|---|---|---|---|
| Rahul | 150000 | 90 | |
| Priya | 120000 | 75 | |
| Amit | 90000 | 85 | |
| Neha | 180000 | 95 |
Excel Formula (D2):
=AND(B2>=100000,C2>=80)
Expected Result:
| Employee Name | Monthly Sales | Performance Score | Bonus Eligibility |
|---|---|---|---|
| Rahul | 150000 | 90 | TRUE |
| Priya | 120000 | 75 | FALSE |
| Amit | 90000 | 85 | FALSE |
| Neha | 180000 | 95 | TRUE |
Explanation: Both conditions must be satisfied. Priya does not qualify because her performance score is below 80. Amit does not qualify because his sales are below ₹1,00,000.
Concept Covered: Checking business eligibility using two conditions.
Question 3: Check Employee Promotion Eligibility
Problem Statement: An HR department wants to identify employees eligible for promotion based on three requirements.
Conditions:
- Experience must be at least 3 years.
- Performance score must be 85 or above.
- Attendance must be at least 22 days per month.
Employee Data:
| Employee Name | Experience (Years) | Performance Score | Attendance | Promotion Eligibility |
|---|---|---|---|---|
| Rahul | 5 | 90 | 25 | |
| Priya | 4 | 80 | 26 | |
| Amit | 2 | 95 | 24 | |
| Neha | 6 | 88 | 20 |
Excel Formula (E2):
=AND(B2>=3,C2>=85,D2>=22)
Expected Result:
| Employee Name | Experience (Years) | Performance Score | Attendance | Promotion Eligibility |
|---|---|---|---|---|
| Rahul | 5 | 90 | 25 | TRUE |
| Priya | 4 | 80 | 26 | FALSE |
| Amit | 2 | 95 | 24 | FALSE |
| Neha | 6 | 88 | 20 | FALSE |
Explanation: Excel checks all three requirements. Only Rahul satisfies every condition, so his result is TRUE.
Concept Covered: Testing three or more conditions together.
Question 4: Check Product Availability
Problem Statement: An online store wants to display a product as available for sale only when its stock is greater than zero and its status is Active.
Product Data:
| Product | Stock | Status | Availability |
|---|---|---|---|
| Laptop | 15 | Active | |
| Mouse | 0 | Active | |
| Keyboard | 25 | Inactive | |
| Monitor | 10 | Active |
Excel Formula (D2):
=AND(B2>0,C2="Active")
Expected Result:
| Product | Stock | Status | Availability |
|---|---|---|---|
| Laptop | 15 | Active | TRUE |
| Mouse | 0 | Active | FALSE |
| Keyboard | 25 | Inactive | FALSE |
| Monitor | 10 | Active | TRUE |
Explanation: The formula checks whether stock is available and the product status is Active. Both conditions must be TRUE.
Concept Covered: Combining numeric and text conditions.
Question 5: Display Custom Results Using AND with IF
Problem Statement: A company wants to display “Eligible for Incentive” or “Not Eligible” instead of TRUE or FALSE.
An employee qualifies when monthly sales are at least ₹1,50,000 and the performance score is at least 90.
Employee Data:
| Employee Name | Monthly Sales | Performance Score | Incentive Status |
|---|---|---|---|
| Rahul | 180000 | 95 | |
| Priya | 160000 | 85 | |
| Amit | 120000 | 92 | |
| Neha | 200000 | 98 |
Excel Formula (D2):
=IF(AND(B2>=150000,C2>=90),"Eligible for Incentive","Not Eligible")
Expected Result:
| Employee Name | Monthly Sales | Performance Score | Incentive Status |
|---|---|---|---|
| Rahul | 180000 | 95 | Eligible for Incentive |
| Priya | 160000 | 85 | Not Eligible |
| Amit | 120000 | 92 | Not Eligible |
| Neha | 200000 | 98 | Eligible for Incentive |
Explanation: AND checks both requirements. IF displays a meaningful message depending on whether both conditions are TRUE.
Concept Covered: Using AND inside IF to display custom messages.
Important Concepts to Understand
1. All Conditions Must Be TRUE
AND returns TRUE only when every condition is satisfied.
2. One FALSE Condition Makes the Result FALSE
Even if four conditions are TRUE, one FALSE condition makes the overall AND result FALSE.
3. AND Can Check Multiple Data Types
You can check numbers, text values, dates, and other logical conditions in the same formula.
4. AND Returns TRUE or FALSE
By itself, AND returns a logical result. You can combine it with IF when you want to display custom messages.
Student Practice Tasks
Task 1: Student Scholarship Eligibility
A student qualifies for a scholarship when Mathematics marks are at least 80, English marks are at least 75, and Science marks are at least 80.
| Student | Mathematics | English | Science | Eligibility |
|---|---|---|---|---|
| Aman | 90 | 85 | 88 | |
| Riya | 85 | 70 | 90 | |
| Mohit | 80 | 78 | 82 |
Write an AND formula to check scholarship eligibility.
Task 2: Employee Leave Approval
An employee can receive leave approval when the employee has at least 10 available leave days and has completed at least 6 months in the company.
| Employee | Available Leave Days | Months of Service | Approval |
|---|---|---|---|
| Rahul | 12 | 8 | |
| Priya | 5 | 12 | |
| Amit | 15 | 4 |
Use AND to check whether both requirements are satisfied.
Final Student Challenge: Build an Employee Incentive Eligibility Sheet
Create a worksheet that checks whether employees qualify for a special incentive.
Conditions:
- Monthly Sales must be at least ₹2,00,000.
- Performance Score must be at least 85.
- Attendance must be at least 24 days.
Given Data:
| Employee Name | Monthly Sales | Performance Score | Attendance | Incentive Status |
|---|---|---|---|---|
| Rahul | 250000 | 90 | 26 | |
| Priya | 220000 | 80 | 25 | |
| Amit | 180000 | 95 | 26 | |
| Neha | 300000 | 92 | 22 | |
| Karan | 240000 | 88 | 25 |
Your Challenge: Use AND with IF to display “Incentive Approved” when all three conditions are satisfied; otherwise, display “Not Approved”.
Key Takeaways
- AND checks multiple conditions simultaneously.
- All conditions must be TRUE for AND to return TRUE.
- One FALSE condition makes the complete result FALSE.
- AND can check numbers, text, dates, and other logical tests.
- AND can be combined with IF to display custom messages.
- It is useful for employee eligibility, student results, sales targets, and business decisions.
Frequently Asked Questions (FAQs)
1. What is the AND function in Excel?
The AND function checks multiple conditions and returns TRUE if all conditions are satisfied.
2. What happens if one condition is FALSE?
The AND function returns FALSE if even one condition is FALSE.
3. Can AND check more than two conditions?
Yes. AND can check multiple conditions in a single formula.
4. Can AND work with text conditions?
Yes. For example, you can check whether a product status is “Active” using C2="Active".
5. What is the difference between AND and OR?
AND requires all conditions to be TRUE, whereas OR returns TRUE when at least one condition is TRUE.
6. Can I use AND with IF in Excel?
Yes. Combining AND with IF allows you to display custom results such as “Eligible” or “Not Eligible”.
7. Does AND return TRUE or FALSE?
Yes. By itself, the AND function returns either TRUE or FALSE.
8. Where is the AND function used in real business situations?
It is commonly used for employee eligibility, incentive calculations, sales targets, attendance checks, stock availability, and approval conditions.

