Test scores
I am trying to have a column that will tell me if a student has passed, they can only pass if they get a 60% score for each section, there are four sections.
eg; Cell A1 has a score out of 30 so pass mark is 18
Cell B1 has a score out of 35 so pass mark is 21
Cell C1 has a score out of 35 so pass mark is 21
Cell D1 is marked as Pass or Not Pass
so to get a overall pass the student will need to get at least the minimum score
for each test. As I have over 400 results it would be great if the final score could be calculated for me if possible in excel.
Any help will be appreciated,
- sageplay's blog
- Login or register to post comments
- 5535 reads
Test Scores
There could be dozens of solution to this problem. One way would be the following:-
1) Determine the percentage achieved for each section.
2) Enter the following formula for each section:-
Parameters used:
Section 1 = a, 2, = b, etc.
% achieved = x%
First Formula: Result_a=if(a_x% =>60%,1,0), Result_b=if(b_x% =>60%,1,0), etc
Second Formula: =if((Result_a+ Result_b+Result_c+Result_d))=>4,"pass","Failed")
3) Not sure what you want to calculate with the 400 results. If you want to know how many students passed, use a countif formula