How to Use AND function in Excel

by on May 2, 2017

AND Function

AND function in excel will return TRUE if all the conditions are met otherwise it will return FALSE. With the help of an example, it will be more clear to you. We have a list of students along with their Marks for the three papers. Passing criteria as you can see is 50 or above. Based upon AND formula results the management will prepare Certificates for the successful students.

How to Use AND function in Excel

Step 1: Incorporate the following formula in cell (E4) =AND(B4>=50,C4>=50,D4>=50)

The formula will return TRUE if in all three papers the student gets 50 or more marks and will return FALSE if even in one paper the student gets short of 50 marks.

Step 2: Copy and paste the formula to cells E4:E11. Results are provided below.

How to Use AND function in Excel

How to Use AND function in Excel

Please follow and like us:
0

Leave a Reply

Your email address will not be published. Required fields are marked *