Formula compare two different cells containing the scores of tes

Closed

ayili - 17 Sep 2014 à 10:37
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Sep 2014 à 10:59

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.

Formula compare two different cells containing the scores of tes
Beyond compare - Download - File management
How to merge and compare two excel files - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
"Compare versions word" - Guide
1st, 2nd, 3rd position formula in excel - Excel Forum

1 response

Réponse 1 / 1

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 Sep 2014 à 10:59

Hi Ayili,

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

Best regards,
Trowa

Similar discussions

Clear cell contents based on value of another cell range using VBA

How to calculate positions (1st,2nd,3rd...) in Excel

help me to add particular cells

How to Compare two workbooks and see if data has moved or not?

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme

Similar discussions

Subscribe To Our Newsletter!