EXCEL AND FUNCTION
  EXCEL AND function allows you to test multiple conditions and returns TRUE if all of the specified conditions are TRUE    else, it returns FALSE.
Syntax:
 =AND(logical1,[logical2],…..)
Arguments or Parameters
logical1: first condition given.
logical2: second condition given.
Objective: Find cells in a given range where Experience is greater than 5 and State Code is AL.
   Step 1:
Type = sign in E2 cell
Type AND Function
   Step 2:
The C2 column refers to Experience.
Type logical1 : C2>5
Type “,”
   Step 3:
The D2 column refers to the State Code.
Type logical2: D2=”AL”
Close bracket with “)”
Press Enter
Result: AND Function has given True to all the cells in range E2:E20 where Exp is greater > 5 and State code is AL.
Â
