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..
Bookmarks