Requiring Everything With AND

Sometimes a single condition cannot answer your question. Imagine deciding whether a job applicant qualifies: they need both 5 years of experience and a valid certificate. One condition is not enough on its own.

The AND function lets you bundle several tests together. It returns TRUE only when every condition you give it is true. If even one fails, the whole thing becomes FALSE.

This lesson shows you how to require everything at once, so your spreadsheet only says yes when all the boxes are ticked.

The AND function takes a list of logical tests, separated by commas, and checks them all:

• logical1 the first condition to test
• logical2 the next condition, and so on

You can pass up to 255 conditions. Each one must be something that evaluates to TRUE or FALSE, like a comparison.

The result is a single TRUE or FALSE for the whole group. Think of it as the word and in plain English: this and that and the other.

Suppose cell A2 holds a test score and B2 holds an attendance percentage. A student passes only if they scored at least 60 and attended at least 80% of classes.

The formula below checks both conditions. If the score is 72 and attendance is 90, both tests are true, so the result is TRUE. If attendance were only 70, the second test fails and the whole formula returns FALSE.

By itself, AND just shows the word TRUE or FALSE in the cell. That is useful, but often you want a friendlier answer.

The key idea: AND produces a single logical value. Walk through it mentally, one test at a time. The moment any test is false, you can stop, because the answer is already FALSE.

• All true to all true to TRUE
• Any one false to FALSE

Next we will feed that result into IF to show real words.

The real power appears when you nest AND inside an IF. The IF function takes a test, then what to show when true, then what to show when false.

Here, AND(A2>=60, B2>=80) becomes the test. If both conditions hold, the cell shows Pass. Otherwise it shows Fail.

This pattern, IF wrapping AND, is one of the most common building blocks in real spreadsheets.

A bank approves a loan only if the applicant has an income above 50000 and a credit score above 700 and no current default.

With income in C2, credit score in D2, and a defaults count in E2, the formula checks all three at once. Notice you can chain as many conditions as you need inside one AND.

If all three pass, the result is Approved; if any single one fails, it is Declined.

Conditions inside AND do not have to be numbers. You can compare text too. Just remember to wrap text values in straight double quotes.

This example checks that the region in A2 is exactly East and the sales figure in B2 is over 1000.

Text comparisons are not case sensitive in Excel and Sheets, so East, east, and EAST all match here.

A classic use of AND is checking whether a value sits between two limits. Spreadsheets cannot do 0 < A2 < 100 in one piece, so you split it into two tests joined by AND.

The formula below returns TRUE only when the value in A2 is greater than 0 and less than 100, meaning it falls inside that range.

You can also point AND at a whole range. When you do, every cell in that range must satisfy the comparison for the result to be TRUE.

The formula below returns TRUE only when all the values in A2:A10 are greater than zero. If even one cell is zero or negative, the answer is FALSE.

This is a quick way to confirm an entire column meets a rule.

New users sometimes write AND like a sentence, separating conditions with words instead of commas. That will not work.

• Wrong: =AND(A2>60 and B2>80)
• Right: =AND(A2>60, B2>80)

Each condition is its own argument, divided by a comma. Also avoid quoting numbers: write A2>60, not A2>"60", since quotes turn 60 into text and can break the comparison.

The AND function is the strictest kind of logic: it demands that everything be true. That makes it perfect for gatekeeping decisions like eligibility, approvals, and quality checks where no single failure can be ignored.

Keep these habits in mind:

• Separate conditions with commas
• Wrap text values in quotes, not numbers
• Nest inside IF to show readable words

Now try a quick check to lock it in.

Test your understanding of how the AND function behaves.

You learned that AND returns TRUE only when every condition passes, and FALSE if even one fails.

• Syntax: =AND(test1, test2, ...) with comma-separated conditions
• Nest it in IF for readable results: =IF(AND(...), "Yes", "No")
• Use it for between-range checks like =AND(A2>0, A2<100)
• Compare text by wrapping values in quotes

Next up: OR, which is satisfied when just one condition is true.