Syntax: =AND(1st criteria to test, second criteria to test, third criteria to test,…) and the function will return “TRUE” or “FALSE”.
Use : The AND function is used to determine if more than one criteria is occurring at once. Other similar Microsoft Excel functions include IF and OR.
Example 1 :
Allows user to test more than one criteria at a time; much easier than multiple imbedded IF statements.