What it does
AND takes as many conditions as you like: =AND(B2>=70,C2>=0.8). If they are all TRUE the result is TRUE; if even one is FALSE, it is FALSE. The result can stand on its own as a check column, or go into the test of IF to become a label or a calculation.
AND is the right way to test whether a value lies between two limits: =AND(B2>=$F$2,B2<=$G$2). Writing F2<=B2<=G2 as in maths does not work in Excel; Excel does the first comparison and then compares its TRUE or FALSE with the second limit.
If any one condition is enough, use OR; to reverse a condition, use NOT. To count or add up the rows that meet several conditions, COUNTIFS and SUMIFS are more direct.
Syntax
=AND(logical1, [logical2], ...)=VE(mantıksal1; [mantıksal2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
logical1 | Required | The first condition, one that results in TRUE or FALSE, e.g. B2>=70. |
logical2 | Optional | The next condition to test; up to 255 conditions are allowed. |
Examples
1Check whether two requirements are both met
To pass, the exam score must be at least 70 and attendance at least 80%. The formula in D2 is filled down and gives TRUE or FALSE for each student.
=AND(B2>=70,C2>=0.8)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Exam | Attendance | Passed? |
| 2 | Mia | 82 | 95% | TRUE |
| 3 | Lucas | 91 | 72% | FALSE |
| 4 | Ella | 68 | 88% | FALSE |
| 5 | Jack | 70 | 80% | TRUE |
- D2 (filled down to D5)
=AND(B2>=70,C2>=0.8)
Lucas has a high score, but his attendance is below 80%, so D3 shows FALSE. Jack is exactly on both thresholds, so the >= tests are true: TRUE.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Check an invoice against a campaign period and an amount
The campaign covers invoices dated 1-31 October and above 1,000. The period limits are in F2 and G2; AND gets three conditions and IF turns the result into a label.
=IF(AND(B2>=$F$2,B2<=$G$2,C2>1000),"Eligible","Not eligible")| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Invoice | Date | Amount | Campaign | Start | End | |
| 2 | F-3101 | 28-Sep-2026 | 1,450.00 | Not eligible | 1-Oct-2026 | 31-Oct-2026 | |
| 3 | F-3102 | 1-Oct-2026 | 860.00 | Not eligible | |||
| 4 | F-3103 | 17-Oct-2026 | 2,300.00 | Eligible | |||
| 5 | F-3104 | 31-Oct-2026 | 1,200.00 | Eligible | |||
| 6 | F-3105 | 2-Nov-2026 | 3,100.00 | Not eligible |
- D2 (filled down to D6)
=IF(AND(B2>=$F$2,B2<=$G$2,C2>1000),"Eligible","Not eligible")
F-3102 is inside the period but its amount is too low: Not eligible. F-3104, issued on the last day of the period, is Eligible. F-3105 has a large amount but falls outside the period: Not eligible.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #VALUE!
Cause: None of the conditions produces a logical value, for example a range that holds only text was passed.
Fix: Write the conditions as comparisons:
B2="Yes".- Always FALSE
Cause: The numbers being compared are stored as text, or a range test was chained like
F2<=B2<=G2.Fix: Convert the numbers to real numbers; write the range test as two conditions:
AND(B2>=F2,B2<=G2).
Good to know
- AND does not work row by row on a range; it reduces the whole range to one result. For an "and" test across many rows, multiply the conditions:
(B2:B9>=70)*(C2:C9>=0.8). - Put the date limits in cells (
$F$2,$G$2) instead of typing them into the formula; when the period changes you only update those cells.
In Nexell
Get Nexell to do it from a sentence
In the invoice list, write "Eligible" next to invoices dated in October with an amount over 1,000
Convert to tableBring your invoice list into the tool and type this. Nexell adds the conditional column with real Excel formulas and the preview shows which invoices qualify; in the downloaded file, the mark changes when a date or an amount does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I use IF with AND?
Put AND in the test of IF: =IF(AND(B2>=70,C2>=0.8),"Pass","Fail"). If both requirements are met it shows "Pass"; if either one fails it shows "Fail".
How do I check whether a date is between two dates in Excel?
Give AND the start and end as two separate conditions: =AND(B2>=DATE(2026,10,1),B2<=DATE(2026,10,31)). Use >= and <= to include the boundary days.