Logical Function in Excel: AND Function
And Function checks one or more given Logical Criteria and if all the given logical criteria are True then return a Value of True, otherwise false.
Syntax of AND Function
= AND (logical1, logical2, ... )
Example of AND function
In the above example there are two subject result is given and passing marks in each of the subject is 30. So, this is to check that, if a student able to score passing marks in both the subject or not. If student score more than 30 marks (Marks in Col. C and Col. D is greater than 30) then it return “True”, and if Not then it will give a value “False”.