The Microsoft Excel AND Function

Command: AND

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.