Skip to content

Excel function · Logical

Excel AND function

AND returns TRUE when every condition you give it is true and FALSE when at least one is false. Use it for combined checks such as pass requirements or whether a date falls inside a period.

In Turkish Excel: VE

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

English Excel=AND(logical1, [logical2], ...)
Turkish Excel=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

ArgumentRequiredDescription
logical1RequiredThe first condition, one that results in TRUE or FALSE, e.g. B2>=70.
logical2OptionalThe 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.

D2fx=AND(B2>=70,C2>=0.8)
Check whether two requirements are both met: example table
ABCD
1StudentExamAttendancePassed?
2Mia8295%TRUE
3Lucas9172%FALSE
4Ella6888%FALSE
5Jack7080%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.

D2fx=IF(AND(B2>=$F$2,B2<=$G$2,C2>1000),"Eligible","Not eligible")
Check an invoice against a campaign period and an amount: example table
ABCDEFG
1InvoiceDateAmountCampaignStartEnd
2F-310128-Sep-20261,450.00Not eligible1-Oct-202631-Oct-2026
3F-31021-Oct-2026860.00Not eligible
4F-310317-Oct-20262,300.00Eligible
5F-310431-Oct-20261,200.00Eligible
6F-31052-Nov-20263,100.00Not 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

Type this in Nexell

In the invoice list, write "Eligible" next to invoices dated in October with an amount over 1,000

Convert to table

Bring 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.

Related functions

All logical functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free