Marksheet formula

[Muthukrishnan V]

Excel 2007



Reg: Marksheet formula


Columns B to J are in numerical format containing marks
obtained.



Helper Cell K1 contains 50 in numerical format, minimum
required marks for a "Pass".


Columns B,C & D are category 1 and student should pass at
least 2 subjects (out of 3)


Columns E,F & G are category 2 and student should pass at
least in 1 subject (out of 3)



Columns H,I & J are category 3 and student should pass in all
the 3 subjects (out of 3)


So, a student is required to pass a minimum of 6 out of 9
subjects (2 in B:D; 1 in E:G; and 3 in H:J) to qualify.



Kindly advise me a formula to get the resultant output
"Qualified" or else "Not Qualified".


Thanking you,

 

[Michael M]

Maybe this

=IF(AND(COUNTIF(B1:D1,">="&K1)>1,COUNTIF(E1:G1,">="&K1)>=1,COUNTIF(H1:J1,">="&K1)>2),"Qualified","fail")

 

[Muthukrishnan V]

Sir,

I am sorry and apologise for my very late response. Kindly excuse me.

The above code returns "too many aruguments for this function". Please advise me I use MS Excel 2007

 

[Michael M]

Works fine for me !
Did you copy the formula provided OR retype it ??

 

[Michael M]

Can you post a SMALL sample of your data ?

 

[Muthukrishnan V]

Sir, I retyped the formula

 

[Michael M]

Try simply doing a copy and paste of the formula....why retype it ???

 

[Muthukrishnan V]

Sir, I did as what you said Great, Ir works fine. Thanking you, Sir

 

[Michael M]

Glad it worked for you...?