Need formula for Group Exemption from Theory, Internal & Practical

[vijubhau]

Respected Sir,

There is a Group of subject in the marksheet, which one subject contains only "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) marks
and another subject in the marksheet, which contains "Theory"(Passing Marks=20), "Internal"(Passing Marks=8) & "Practical"(Passing Marks=12) marks

I used the following formula for the result for the subject which contains only "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) marks
=IF(OR(COUNT(G2:H2)=0,AND(G2<32,H2<8)),"",IF(AND(OR(G2<32,ISTEXT(G2)),H2>=8),"P",IF(AND(G2>=32,OR(H2<8,ISTEXT(H2))),"T",IF(AND(G2>=32,H2>=8),"F"))))
And it is showing the PERFECT RESULT...

Then How can I insert the another formula for the result IN THE SAME CELL EITHER contains "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) OR contains "Theory"(Passing Marks=20), "Internal"(Passing Marks=8) & "Practical"(Passing Marks=12) marks


Thanks in advance..

[vijubhau]

I am using the following formula for the exemption..

=IF(OR(COUNT(B2:D2)=0,AND(B2<20,C2<8,D2<12)),"",IF(AND(OR(B2>=20,ISTEXT(B2)),D2>=12),"TP",IF(AND(OR(C2>=8,ISTEXT(C2)),D2>=12),"IP",IF(AND(B2>=20,OR(C2>=8,ISTEXT(C2))),"TI",IF(AND(OR(B2<20,ISTEXT(B2)),C2>=8),"I",IF(AND(B2>=20,OR(C2<8,ISTEXT(C2))),"T",IF(AND(B2>=20,C2>=8,D2>=12),"F")))))))

But it is not working properly... It is showing the result as "TP" if all criteria has a sufficient marks for passing...

[vijubhau]

I need "F" inspite of "TP"

[JeteMc]

To get "F" in spite of "TP" try:

Please Login or Register  to view this content.

This also clears up the conflict where B2 is text and C2 is 8 or more. I assume that in that case the result should be "I" however the formula in post #2 yielded "TI".
This does not clear up the conflict where B2 is 20 or more and C2 is text. The result will be "TI" although it also seems to meet the conditions for "T"
Attached is a sample of various inputs with their outputs and my expected outputs.
Let us know if you have any questions.