The IF with AND combination in Excel allows you to test multiple conditions at the same time and return different results depending on whether all conditions are true. It is one of the most useful formula combinations for decision-making in spreadsheets, especially in sales tracking, employee evaluations, budgeting, inventory management, and qualification checks.
Instead of checking only one condition, combining IF with AND lets Excel evaluate several requirements at once. If all conditions are met, Excel returns a single result. If even one condition fails, Excel returns another result.
In This Guide, You’ll Learn
- What the IF with AND formula does
- How the IF and AND functions work together
- The syntax and arguments of IF with AND
- How to test multiple conditions at once
- Practical IF with AND examples you can use immediately
- Common mistakes to avoid when combining IF and AND
What is the IF with AND Formula in Excel?
The IF with AND formula checks whether multiple conditions are true before returning a result.
The AND function evaluates multiple logical tests. If all conditions are true, AND returns TRUE. If even one condition is false, it returns FALSE.
The IF function then uses that TRUE or FALSE result to determine what Excel should display.
For example, you might want to:
- Approve a sales bonus only if a target is met and customer feedback is high
- Determine whether an employee qualifies for overtime approval
- Check if a student passes multiple requirements
- Verify customer discount eligibility
IF with AND Formula Syntax
=IF(AND(logical_test1,logical_test2,...),value_if_true,value_if_false)Argument Definitions
- logical_test1, logical_test2,… — The conditions Excel evaluates.
- value_if_true —What Excel returns if all conditions are true.
- value_if_false —What Excel returns if one or more conditions are false.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> IF AND Function Data
How IF and AND Work Together
The AND function checks whether all conditions are true.
Then:
- If AND returns TRUE, IF returns the value_if_true
- If AND returns FALSE, IF returns the value_if_false
Think of it this way:
All conditions met? → Yes = one result | No = another result
Check if a Sales Goal Was Met
Suppose a salesperson qualifies for a bonus only if:
- Sales are at least $5,000
- Customer satisfaction score is 90 or higher
Use this formula:
=IF(AND(B2>=5000,C2>=90),"Bonus","No Bonus")
Determine Employee Eligibility
Suppose an employee qualifies for overtime approval only if:
- Worked at least 40 hours
- Has manager approval marked Yes
Use this formula:
=IF(AND(B2>=40,C2="Yes"),"Approved","Denied")
Determine Student Passing Status
A student passes only if:
- Test score is at least 70
- Attendance is at least 80%
Use this formula:
=IF(AND(B2>=70,C2>=80),"Pass","Fail")
Product Discount Qualification
Suppose customers qualify for a discount only if:
- Purchase amount is at least $100
- They are a member
Use this formula:
=IF(AND(A2>=100,B2="Yes"),"Qualified","Not Qualified")
Return TRUE or FALSE Instead of Text
Sometimes you may want Excel to return a TRUE/FALSE result instead of text labels.
Use this formula:
=IF(AND(B2>=100,C2="Yes"),FALSE,TRUE)
This formula checks whether someone is not qualified.
If both conditions are met, Excel returns FALSE. Otherwise, Excel returns TRUE.
Common IF with AND Mistakes to Avoid
Forgetting Parentheses
Incorrect:
=IF(AND B2>=100,C2="Yes","Qualified","No")Correct:
=IF(AND(B2>=100,C2="Yes"),"Qualified","No")Forgetting Quotation Marks Around Text
Incorrect:
=IF(AND(B2>=100,C2=Yes),"Qualified","No")Correct:
=IF(AND(B2>=100,C2="Yes"),"Qualified","No")Confusing AND with OR
Remember:
- AND = all conditions must be true
- OR = only one condition must be true
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> IF AND Function Data
