Z
Zainuddin Zakaria
Dear all, I still cant get the correct formula for this.
Please help me. Thaank you.
Please help me. Thaank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
M
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: "".
(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: "".
Z
Zainuddin Zakaria
Thank you so much, Max.
I will try the formula. Have a nice week.
I will try the formula. Have a nice week.
D
Dave Peterson
And don't forget to check your original thread, too.
M
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.
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.
Z
Zainuddin Zakaria
Thank you so much for your help.
Great formula .... I appreciate it.
Great formula .... I appreciate it.