Still can't get the correct formula for marksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zainuddin Zakaria - 25 Sep 2006 07:02 GMT

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

>Thanks a lot, Dave.
>But if I leave all the cells blank, the overall result shows the student
>'Passed' the exam.
>This shouldn't be. How to solve this? Any other formula, Dave.
>Thank you again.

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4516C167.9401B79F@verizonXSPAM.net...

> One way:

> =IF(OR((ISNUMBER(SEARCH("e",E7&G7&I7&K7))),(M7&O7&Q7="eee"),(S7&U7="ee")),
> "Failed","Passed")

> Zainuddin Zakaria wrote:

>> Please help me with a formula for my marksheet.
>> The exam grading is A, B, C, D and E. E is a failure
>> To pass the overall exam, a student must :-

>> Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
>> and MUST PASS ONE subject from column M7, O7, or Q7
>> and MUST PASS ONE subject from column S7, or U7

>> What is the best formula for this?

>> Thank you for your time.

Reply to this Message

Bob Phillips - 25 Sep 2006 07:36 GMT

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

Signature

HTH

Bob Phillips

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

> Dear all, I still cant get the correct formula for this.
> Please help me. Thaank you.
[quoted text clipped - 6 lines]
>
> > One way:

=IF(OR((ISNUMBER(SEARCH("e",E7&G7&I7&K7))),(M7&O7&Q7="eee"),(S7&U7="ee")),

> > "Failed","Passed")
>
[quoted text clipped - 11 lines]
>
> >> Thank you for your time.

Reply to this Message

Max - 25 Sep 2006 09:51 GMT

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: "".

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

Zainuddin Zakaria - 25 Sep 2006 10:28 GMT

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

> Here's a response posted in your original thread
> (you should stay within that thread)
[quoted text clipped - 9 lines]
>> Dear all, I still cant get the correct formula for this.
>> Please help me. Thaank you.

Reply to this Message

Max - 26 Sep 2006 02:59 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

Dave Peterson - 25 Sep 2006 13:06 GMT

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

> Dear all, I still cant get the correct formula for this.
> Please help me. Thaank you.
[quoted text clipped - 23 lines]
>
> >> Thank you for your time.

Signature

Dave Peterson

Reply to this Message

Zainuddin Zakaria - 28 Sep 2006 04:37 GMT

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

> And don't forget to check your original thread, too.
>
[quoted text clipped - 25 lines]
>>
>> >> Thank you for your time.

Reply to this Message