If statement usage

[sekharsomu]

I am having a STUDENT MARKS SHEET ,
Until now i used to verify whether a student is passed or failed the marks using the formula:

=IF((MIN(D3,E3,F3,G3:H3,I3,J3)>=35),"P","F")

as you see d3,e3,f3... are different subject rows.
Now the problem is a group of subjects have a pass mark of 28 and others have 35
so i try the following ways

=IF(AND(MIN(D3,E3,F3,G3)>=28,MIN(H3,I3,J3)>=35)),"P","F")

=IF(D3>=28,"P",IF(E3>=28,"P",IF..................","P","F"))))

But none of them is working......
please suggest me a solution

[DonkeyOte]

Can you provide a sample ?

As I see it this (with parentheses corrected) should work:

=IF(AND(MIN(D3,E3,F3,G3)>=28,MIN(H3,I3,J3)>=35),"P","F")

should work... though as the ranges are contiguous you can shorten to:

=IF(AND(MIN(D3:G3)>=28,MIN(H3:J3)>=35),"P","F")

[sekharsomu]

Thanq it has worked