# And Test

This Excel Tutorial demonstrates how to use the

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

[fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”]

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.

[/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]