I would like some formula for students score

[sakijung]

Happy New Year and Sawasdee from Thailand. I have a file that I would
like anyone who can help me to solve my problem. Please d/l my file and
help me please.... Thank you

Attachment filename: mark.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=404449

 

[Fabian]

Happy New Year and Sawasdee from Thailand. I have a file that I would

like anyone who can help me to solve my problem. Please d/l my file
and help me please.... Thank you

Not saying you would purposely send a virus, but excel is known to be a
possible carrier for many viruses. A lot of people here won't download
that file on principle. You would have more and better responses if you
include your problem in the message.

 

[Don Guillett]

Although it appears that opening files from here is pretty safe, you will
get much more help if you FULLY explain your problem and give examples with
the desired answer. Many will have the attitude that if you can't bother to
do this why should they bother to help.

BTW I did look at your file and couldn't figure out what you
wanted............

 

[Norman Harker]

Sawasdee Khun Sakijung!

That's not the way we work here as others have explained. But we're
very friendly to newcomers to these groups.

To return - if there is missing data you need:

=IF(COUNTA(E7:H7)<4,"-",IF(SUM(E7,G7)>=10,"-",(IF(E7>F7,E7,F7)+IF(G7>H
7,G7,H7))))

You second question is confusing. From context I think that you want
the result to be as scored but *not* more than 10. In other words if
they have had a re-test, then the maximum achieved should be 10.

That would be:
=IF(COUNTA(E7:H7)<4,"-",IF(SUM(E7,G7)>=10,"-",MIN(10,(IF(E7>F7,E7,F7)+
IF(G7>H7,G7,H7)))))

But if I've misunderstood, please post back.

Sawasdee Krab.
--
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[sakijung]

I try the last answer and it's very good to use for my job. Thank you
again. This answer can help my teachers in school and help my duty in
Registra Department.

 

[sakijung]

I try the last answer and it's very good to use for my job. Thank you
again fory any suggestion when I post the problem. This answer can
help my teachers in school and help my duty in Registra Department.

 

[Norman Harker]

Sawasdee Khun Sakijung!

Mai me panha!

Maybe see you in Bangkok soon where I'm hoping to run some Excel
courses.

Keep posting
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.