Google Sheets AND Function

AND Function

TheAND function is a premade function in Google Sheets, which returnsTRUE orFALSE based on two or moreconditions.

It is typed=AND and takes two or more conditions.

Theconditions are referred to as[logical_expression1],[logical_expression2], and so on.

The conditions can check things like:

• If a number isgreater than another number>
• If a number issmaller than another number<
• If a number or text isequal to something=

Example AND Function

Check if the Pokemon type is fireand has speedgreater than 70:

The function returns "TRUE" or "FALSE".

NameType 1SpeedFire Type AND more than 70 Speed BulbasaurGrass45 IvysaurGrass60 VenusaurGrass80 CharmanderFire65 CharmeleonFire80 CharizardFire100 SquirtleWater43 WartortleWater58 BlastoiseWater78

Copy Values

ExampleAND function, step by step:

1. Select the cellD2
2. Type=AND
3. Click theAND command

4. Specify the first conditionB2="Fire"
5. Type,
6. Specify the second conditionC2>70
7. Hit enter

Since the value in cellB2 is not "Fire" the first condition isFALSE.

Since the value in cellC2 is less than 70 the second condition is alsoFALSE.

All conditions need to beTRUE for the AND function to returnTRUE.

The function can be repeated with thefilling function for each row to perform the same check for each Pokemon:

Only Charmeleon and Charizard both have Fire type and speed greater than 70, so the function returns "TRUE".

Example AND Function (with IF)

Combining the AND function with anIF function lets you checkmultiple conditions for the IF function:

The IF function is typed=IF and has 3 parts:

The AND function takes the place of thelogical_test condition.

Here, theIF function returns "Yes" or "No".

ExampleAND function as the condition forIF function, step by step:

1. Select cellC2
2. Type=IF
3. Click theIF command

4. TypeAND
5. Click theAND command

7. Specify the first conditionB2="Fire"
8. Type,
9. Specify the second conditionC2>70
10. Type),
11. Specify the value"Yes" for when both conditions areTRUE
12. Type,
13. Specify the value"No" for when either, or both, conditions areFALSE
14. Type) and hit enter

The function can be repeated with thefilling function for each row to perform the same check for each Pokemon:

Now each row has a check for both being Fire type and Speed greater than 70:

Only Charmeleon and Charizard both have Fire type and speed greater than 70, so the function returns "Yes".