And
AND Function
With the use of AND function in excel, we use to test multiple conditions at the same time. It returns either TRUE or FALSE.
Normally the AND() function would be used in conjunction with a function such as =IF().
Syntax
=AND(Test1,Test2)
For example, if we have some students mark in two column, first column mark for physics and 2nd column mark for chemistry. I want to declare pass or fail with use of excel function. If student’s mark is greater than 50 in both subject then pass other wise fail. For this first we will use AND function to find our that any subject has mark is greater than 50. Formula will be =AND(B2>50,C2>50), it will returns true or false then we use if function to get result Pass or Fail. Formula will be =IF(AND(B2>50,C2>50),”PASS”,”FAIL”).
Below video can be viewed for more details about AND function.
Click here to view video for AND Function
