AND: make sure every condition is satisfied
AND is for rules where everything must be true: paid, approved and within the reporting window, for example. The exact edge conditions still need your attention.
Both comparisons must be true for the first result to be TRUE. The second row passes attendance but fails the score; the third does the reverse. AND returns a Boolean, and IF converts that Boolean into the label needed for the report.
| Formula | Expected result / interpretation |
|---|---|
| =AND(A2>=70,B2>=80%) | TRUE; fill down for FALSE, FALSE |
| =IF(AND(A2>=70,B2>=80%),”Eligible”,”Review”) | Eligible; fill down for Review, Review |
| Row | A: Score | B: Attendance |
|---|---|---|
| 2 | 75 | 90% |
| 3 | 65 | 95% |
| 4 | 80 | 75% |
Enter scores in A2:A4 and attendance percentages in B2:B4. The rule requires at least 70 points and at least 80% attendance.
Approve a record only when every required test passes
Formula syntax
=AND(logical1, [logical2], ...)
What goes into it
logical1
First condition or logical value.
logical2
Optional additional conditions.
A quick example first
=AND(82>=70,82<=100)
Returns TRUE.
=IF(AND(B2>=70,C2="Complete"),"Ready","Review")
Combines two required conditions inside IF.
Before you copy this into a real sheet
Keep percentages in numeric percentage form. Typing 80 rather than 80% changes the stored value by a factor of 100. Check exact boundaries with a score of 70 and attendance of 80%. Validate missing and text inputs separately; a policy rule should not silently interpret an incomplete record as a normal failure. AND over an array returns an aggregate decision, not necessarily one independent decision per row; in FILTER conditions, multiplication is often the appropriate row-by-row AND pattern.
Useful habits
- Use AND when every condition must be TRUE.
- Keep each condition independently testable while debugging.
- For row-by-row array logic, multiplication of Boolean arrays is sometimes used with FILTER.
Where people get caught out
- Using AND when any one of several conditions should be enough.
- Embedding so many conditions that the business rule becomes difficult to audit.
Other functions worth a look
A detail worth remembering
Test each condition separately with one deliberately failing input. It is the fastest way to see which test is controlling a result.
Reference and examples
The examples above use small, invented datasets and English-language formula names. Check your Excel version and argument separator against the official Excel function reference if a formula behaves differently on your computer.