The Excel AND function test two or more arguments. The function returns a TRUE value if all its arguments are TRUE; returns FALSE if one or more arguments are FALSE. The AND function is often nested within other functions such as ”IF”.

For example:

=if(and(a2=”bob”,a3=”Chuck”),”Yes”,”No)

Syntax:

AND(logical1,logical2, …)

Logical1, logical2, …are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

 

Joseph Harris
ExcelYogi.com
Analyst Resources

Related posts:

1. Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...
2. Vlookup - My Favorite Function Vlookup...
3. Excel CELL () Function The CELL function can be used to find out information...
4. Multiple Condition Vlookup Function Add-in - Excel The question we are asked most often by ExcelYogi readers...
5. Excel Concatenate Function The Excel concatenate function can be used to combine multiple...