This Excel Tutorial demonstrates how to use the

**Excel AND Function**in Excel to test if multiple criteria are all true, with formula examples.

Contents

## AND Function Description:

The AND Function Checks whether all conditions are met. Returns TRUE or FALSE.

## Formula Examples:

Example | Formula | Result |
---|---|---|

No Conditions Met | =AND(C5 > 5,D5 > 5) | False |

One Condition Met | =AND(C6 > 5,D6 > 5) | False |

Two Conditions Met | =AND(C7 > 5,D7 > 5) | True |

Text – Conditions Met | =AND(C8 =”apples”,D8 > 5) | True |

Text <> Equal | =AND(C9 <>”pears”,D9 > 5) | True |

## Syntax and Arguments:

The Syntax for the AND Formula is:

1 |
=AND(logical1,logical2) |

### Function Arguments ( Inputs ):

**logical1** – Logical expressions. Example: A1 > 4.

## Additional Notes

Use the AND Function to simultaneously test multiple conditions. Each condition must be a logical expression (ex: a1 >5), a reference to a cell containing TRUE or FALSE, or an array containing all logical values. If **all** conditions are TRUE, the formula returns TRUE, otherwise it returns FALSE.

AND is a logical function and is generally used in conjunction with another logical function, IF:

The IF Function does one thing if a condition is TRUE and does another if a condition is FALSE. Often when using the AND Function you will “nest” it within an IF Formula.

You may also want to use these other logical functions:

The OR Function tests if **one or more** conditions are met.

The XOR Function tests if **one and only one** condition is met.

Return to the List of all Functions in Excel

## How to use the AND Function in Excel:

To use the AND Excel Worksheet Function…

1. Type the following into a cell:

`=AND(`

2. Notice how the AND Functions inputs appear below the cell:

3. Enter the function inputs.

Note: If you need help with the And Function, after typing “=AND(” into a cell, without leaving the cell, open the *Insert Function Dialog Box* by clicking here:

or by using the shortcut **CTRL + A** (**A** for **A**rguments).

For more information about the AND Formula visit the

Microsoft Website.