Mock Test 1
=IF(A2<10,”free”,IF(AND(A2<15,B2=”male”),15,IF(AND(A2<15,B2=”female”),10,IF(AND(A2<20,B2=”male”),25,IF(AND(A2<20,B2=”female”),20,IF(B2=”male”,40,35))))))
Next method ( nested if)=IF(A2<10,”free”,IF(A2<15,IF(B2=”male”,15,10),IF(A2<20,IF(B2=”male”,25,20),IF(B2=”male”,40,35))))
Mock Test 2
=IF(MIN(C2:G2)>=32,”Pass”,IF(COUNTIF(C2:G2,”<32″)<=2,”Supplimentary”,”Fail”))
Mock Test 3
=IF(E2<=150,200,200+(E2-150)*1.5)
Mock Test 4
=COUNTIFS(A1:A11,”>520″,A1:A11,”<540″)
Mock Test 6
=IF(COUNTIF(C2:G2,”ab”),”A”,RANK(I2,$I$2:$I$6))