Formula compare two different cells containing the scores of tes

Closed
ayili - Sep 17, 2014 at 10:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 23, 2014 at 10:59 AM
Hello,
I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark if his/her score is >49 in both tests. Pls how do i generate such a formula?
Thank u.


Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 23, 2014 at 10:59 AM
Hi Ayili,

Try this:
=IF(AND(A1>49,A2>49),"Pass","Didn't Pass")

Best regards,
Trowa
0