Subscribe!

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. How to Use ISERROR Function in Excel The ISERROR function is a versatile one that is very...
  3. Vlookup – My Favorite Function Vlookup...
  4. Excel CELL () Function The CELL function can be used to find out information...
  5. Multiple Condition Vlookup Function Add-in – Excel The question we are asked most often by ExcelYogi readers...

This entry was posted on Sunday, November 16th, 2008 at 8:48 pm and is filed under Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.