AND Function in Excel and Google Sheets
Purpose
Test multiple conditions and return TRUE only when all of them are true
Return value
TRUE if every argument evaluates to TRUE, FALSE if any one argument is FALSE
AND is the function that enforces multiple requirements at once. Before I understood it, multi-condition checks meant adding helper columns — one for each condition, then reading across them by hand. After AND, every condition collapses into a single logical test. Approve a loan only if the credit score is above 700 AND the income is over 50,000 AND employment is confirmed. Show a bonus only if the rep hit target AND the deal closed in the quarter. Flag a product as available only if stock is above zero AND the listing is active. Any time every condition must be satisfied simultaneously, AND is the right function. It almost always lives inside IF as the logical_test, and it combines cleanly with OR when you need mixed logic. Understanding AND is the foundation of every multi-condition formula I write.
Syntax
✓ Excel 2003+
✓ Google Sheets
= Same syntax
=AND(logical1, [logical2], ...)
Arguments
| Argument | Required | Description |
|---|---|---|
| logical1 | Required | The first condition to test. Any expression that evaluates to TRUE or FALSE — comparisons like A1>100, text matches like B1="Sales", or logical functions like ISBLANK(C1). |
| logical2 ... | Optional | Additional conditions, up to 255 total. AND returns TRUE only when every argument passes. The first FALSE argument stops evaluation immediately and the function returns FALSE. |
How it works
AND evaluates each argument from left to right and returns TRUE only when all of them are TRUE. The moment it finds a FALSE argument it returns FALSE without evaluating the remaining conditions. Numbers are treated as booleans: zero is FALSE and any non-zero number is TRUE, so =AND(1,1,1) returns TRUE and =AND(1,0,1) returns FALSE. AND almost always lives inside an IF — the AND result determines which branch runs. For more complex logic, AND can be combined with OR inside the same IF: =IF(AND(A1>0,OR(B1="VIP",C1>1000)),"Qualify","Decline") requires A1 positive AND either B1 is VIP or C1 exceeds 1000. When you need only one condition to pass, OR is the right choice. When there are many outcome tiers rather than a binary yes/no, IFS handles them in a flat list without deeply nested IFs.
Examples
1
Check whether each loan applicant meets all three approval criteria: credit score above 700, annual income above 50,000, and employment confirmed.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Credit | Income | Employed | Approved |
| 2 | Alice | 750 | 62000 | TRUE | =AND(B2>700,C2>50000,D2=TRUE) |
| 3 | Bob | 680 | 55000 | TRUE | FALSE |
| 4 | Carol | 720 | 48000 | TRUE | FALSE |
| 5 | Dan | 760 | 71000 | FALSE | FALSE |
| 6 | Ella | 800 | 85000 | TRUE | TRUE |
| 7 | Finn | 710 | 52000 | TRUE | TRUE |
Row 2: TRUE
— Alice scores 750 (above 700), earns 62,000 (above 50,000), and is employed — all three conditions pass so AND returns TRUE.
Bob fails the credit threshold at 680. Carol's income is too low at 48,000. Dan's employment flag is FALSE — a single FALSE in any argument makes the whole AND return FALSE. Ella and Finn both pass all three criteria.
2
Mark students Eligible or Not eligible for an exam based on score >= 60 AND attendance >= 75.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Score | Attendance | Status |
| 2 | Alice | 72 | 80 | =IF(AND(B2>=60,C2>=75),"Eligible","Not eligible") |
| 3 | Bob | 55 | 90 | Not eligible |
| 4 | Carol | 88 | 68 | Not eligible |
| 5 | Dan | 65 | 78 | Eligible |
| 6 | Eve | 91 | 82 | Eligible |
Row 2: Eligible
— Alice scored 72 (above 60) and has 80% attendance (above 75) — both conditions pass so AND is TRUE and IF outputs Eligible.
Bob's score of 55 is below 60 so AND fails regardless of his perfect attendance. Carol's attendance of 68 is below 75 so she is excluded despite an 88 score.
3
Flag each product as available only if stock is greater than zero AND the product is marked active.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Stock | Active | Available |
| 2 | Laptop | 12 | TRUE | =AND(B2>0,C2=TRUE) |
| 3 | Mouse | 0 | TRUE | FALSE |
| 4 | Monitor | 5 | TRUE | TRUE |
| 5 | Keyboard | 8 | FALSE | FALSE |
| 6 | Webcam | 3 | TRUE | TRUE |
Row 2: TRUE
— Laptop has 12 units in stock and is active — both conditions are TRUE so AND returns TRUE.
Mouse has zero stock so the first condition fails. Keyboard is not active so the second condition fails regardless of stock level. Both tests must pass for a product to be available.
Common use cases
1. Approve loan applications only when credit score, income, and employment all meet thresholds simultaneously
=IF(AND(B2>700,C2>50000,D2=TRUE),"Approved","Declined")
2. Flag inventory items needing reorder when stock is below minimum AND supplier lead time exceeds threshold
=IF(AND(B2<C2,D2>14),"Reorder now","OK")
3. Mark employees eligible for a year-end bonus when they hit sales target AND hold a performance rating of 4 or above
=IF(AND(C2>=D2,E2>=4),"Bonus","No bonus")
4. Validate a date range entry by confirming start date is before end date AND neither date is blank
=AND(A2<B2,A2<>"",B2<>"")
5. Check that a product price is above cost AND below the maximum retail price for margin compliance
=AND(C2>B2,C2<D2)
Common errors
Returns FALSE when you expected TRUE
One condition is using the wrong operator — a common mistake is = instead of >= so exact boundary values fail. Test each condition individually in separate cells to find the culprit.
Fix: Break the AND into individual cells: =B2>700 in one, =C2>50000 in another. Find the failing condition, then correct its operator or boundary value.
#VALUE! error
One argument references a cell containing text that cannot be interpreted as TRUE or FALSE — for example, the word "yes" instead of the boolean TRUE.
Fix: Check each argument evaluates to a clear TRUE or FALSE by testing in isolation. Text cells that are not the literal words TRUE or FALSE will cause errors in logical arguments.
AND returns TRUE but the IF shows the wrong branch
The AND is correct but the two IF output arguments are swapped — value_if_true and value_if_false are in the wrong positions.
Fix: Double-check the order: the first value after the logical_test is returned when AND is TRUE, the second when AND is FALSE.
Tips and variations
Test AND results in a helper column before embedding in IF
Build the AND formula as a standalone first to confirm it returns TRUE and FALSE for the correct rows. Once verified, wrap it in IF — or use the IF with AND formula pattern which combines both in a single step. Debugging AND, IF, and nested logic all at once is far harder than verifying each layer separately.
=AND(B2>700,C2>50000,D2=TRUE)
Combine AND with OR for mixed requirements
When some conditions are mandatory and others are alternatives, nest OR inside AND. AND(A1>0,OR(B1="VIP",C1>500)) requires A1 positive AND either of the OR conditions true — the pattern behind most customer qualification rules.
=IF(AND(C2>0,OR(D2="Premium",E2>1000)),"Qualify","Pass")
Use IFS when you have more than two outcome tiers
AND inside IF gives you a binary result — eligible or not, approved or declined. When you need three or more distinct outcomes from the same decision, switch to IFS which lists condition-result pairs in a flat structure with no nesting.
=IFS(AND(B2>700,C2>50000),"Approved",B2>650,"Review",TRUE,"Declined")
Excel vs Google Sheets
Excel vs Google Sheets
AND works identically in Excel 2003 and newer and every version of Google Sheets. The syntax, argument limit of 255, and treatment of numbers as booleans are the same in both applications. Formulas copy between them without changes.
Related reading
Frequently asked questions
AND tests multiple conditions and returns TRUE only when every single condition evaluates to TRUE. If even one condition is FALSE, the whole AND returns FALSE. It is most commonly used inside IF as the logical_test argument when you need all criteria to pass simultaneously before a result is shown.
AND accepts up to 255 arguments in Excel and Google Sheets, though in practice most formulas use two to four. Each argument must be an expression that evaluates to TRUE or FALSE. Numbers work too: zero is FALSE and any non-zero number is TRUE.
AND requires all conditions to be true before it returns TRUE. OR requires only one condition to be true. Use AND when every requirement must be met simultaneously. Use OR when meeting any one of several alternatives qualifies.
Yes. AND returns TRUE or FALSE directly, so you can place it in a standalone cell, use it in a FILTER condition, or pass it anywhere a boolean is expected. However it is most commonly paired with IF so the boolean triggers a visible label or calculation rather than displaying the raw word TRUE or FALSE.
Yes. AND is completely identical in both applications. The syntax, argument limit, treatment of numbers as booleans, and behaviour are all the same. Formulas using AND copy between Excel and Google Sheets without any modification.