Still can't get the correct formula for marksheet

[Zainuddin Zakaria]

Dear all, I still cant get the correct formula for this.
Please help me. Thaank you.

 

[Bob Phillips]

Can you post your worksheet to one of the temporary web hosts?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Max]

Here's a response posted in your original thread
(you should stay within that thread)
----------- ----------
Just throwing in some thoughts here in the interim ..
(do hang around for Dave's response)

Perhaps you could try this in say V7:
=IF(OR(LEN(E7&G7&I7&K7)<4,LEN(M7&O7&Q7)<3,LEN(S7&U7)<2),"",IF(AND(SUMPRODUCT(NOT(ISNUMBER(SEARCH("e",E7&G7&I7&K7)))*(LEN(E7&G7&I7&K7)=4))>0,SUMPRODUCT(--(M7={"a","b","c","d"})+--(O7={"a","b","c","d"})+--(Q7={"a","b","c","d"}))>0,SUMPRODUCT(--(S7={"a","b","c","d"})+--(U7={"a","b","c","d"}))>0),"Passed","Failed"))

Above presumes all 9 grade cells must be completed, otherwise it'll just
return blank: "".

 

[Zainuddin Zakaria]

Thank you so much, Max.
I will try the formula. Have a nice week.

 

[Dave Peterson]

And don't forget to check your original thread, too.

 

[Max]

Zainuddin,
Pl also see/try the other responses in your original thread.
Believe Dave & Don have responded further to you.
Do provide feedback to them as well.

 

[Zainuddin Zakaria]

Thank you so much for your help.
Great formula .... I appreciate it.