Logical Function in Excel: AND Function

June 02, 2013

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

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”.

No comments

Share your thoughts

%d bloggers like this: