# Excel AND Function

## AND Function

The AND function is a premade function in Excel, which returns TRUE or FALSE based on two or more conditions.

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

Note: The AND function is often used together with the IF function.

=AND([logical1], [logical2], ...)

The conditions are referred to as `[logical1]`, `[logical2]`, and so on.

The conditions can check things like:

• If a number is greater than another number `>`
• If a number is smaller than another number `<`
• If a number or text is equal to something `=`

Note: The different parts of the function are separated by a symbol, like comma `,` or semicolon `;`

The symbol depends on your Language Settings.

## Example AND Function

Check if the Pokemon type is fire and has speed greater than 70:

The function returns "TRUE" or "FALSE".

Example AND function, step by step:

1. Select the cell `D2`
2. Type `=AND`
3. Double click the AND command

1. Specify the first condition `B2="Fire"`
2. Type `,`
3. Specify the second condition `C2>70`
4. Hit enter

Note: You can add more conditions by repeating steps 5-6 before hitting enter.

Since the value in cell `B2` is not "Fire" the first condition is FALSE.

Since the value in cell `C2` is less than 70 the second condition is also FALSE.

All conditions need to be TRUE for the AND function to return TRUE.

Note: Text values needs to be in quotes: " "

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

Now, each row has a check for Fire Type and Speed greater than 70:

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 an IF function lets you check multiple conditions for the IF function:

Note: The IF function lets you specify the return values.

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

=IF(logical_test, [value_if_true], [value_if_false])

The AND function takes the place of the `logical_test` condition.

Here, the IF function returns "Yes" or "No".

Example AND function as the condition for IF function, step by step:

1. Select cell `C2`
2. Type `=IF`
3. Double click the IF command

1. Type `AND`
2. Double click the AND command

1. Specify the first condition `B2="Fire"`
2. Type `,`
3. Specify the second condition `C2>70`
4. Type `),`
5. Specify the value `"Yes"` for when both conditions are TRUE
6. Type `,`
7. Specify the value `"No"` for when either, or both, conditions are FALSE
8. Type `)` and hit enter

The function can be repeated with the filling 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".

×

## Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com