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

Formula compare two different cells containing the scores of tes
"Compare versions word" - Guide
Beyond compare download - Download - File management
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide
Number to words in excel formula - Guide

1 response

Answer 1 / 1

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

Hi Ayili,

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

Best regards,
Trowa

Similar discussions

help me to add particular cells

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

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

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

Similar discussions

Subscribe To Our Newsletter!