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