Must pass 3 out of 4 subjects | How to find the Eligibility status with multiple criteria
In this video, you will learn how to extract the data for 2 different condition.
In this sheet, there is a table which consist of candidate name and training program they have attended . In order to appear for examination, they should have should 75% attendance in at least 3 subjects out of 4.
In order to extract the data, i have used countif and if function together. Countif will calculate how many subjects are greater than 75 and the same is passed on to if function.If function will evaluate whether it is equal to or more than 3 subjects. If it is true, it will return "eligible", otherwise "Not Eligible".
=if(countif(A4:A7,"greater than=75")greater than-=3,"Eligible","Not Eligible").
#excel #if #countif .
Keep Watching,Keep Learning.