Cossminn

Maybe I have misuderstood what you are trying to achieve but from what you
have written:

If a student fails the final exam or any one test then they are 'rejected'.
Put another way for a student not to be rejected they must have passed all
the tests and the final exam?

If this is the case then this will work:

=IF(AND(C2=5,D2=5,E2=5,F2=5),F2,"REJECTED")

If a student has scored 5 or more on all tests and exams then the final
score on the exam will be displayed (F2). If a student failed any test or the
exam then they are assigned 'REJECTED'.

Does this fit your needs?

Alex

"Cossminnn" wrote:


I'm trying to make a function for a test evaluation. I have 3 columns
with Tests, one with Exam and another one with the final Score.
Now, in the final column is the Situation of the students and it should
look like this:
- if the student passed all the tests and the exam (scoring at least 5
on each), then under Situation will appear the final score.
- if the student fails one of the tests or the exam (scoring under 5),
then it should say "Rejected".
I've tried using the nested IF, but I keep getting an error ("You've
entered too many arguments for this function").
The formula I used is this:
=IF(F2=5;F2;"Rejected";IF(B2<5;"Rejected";F2;IF(C 2<5;"Rejected";F2;IF(D2<5;"Rejected";F2;IF(E2<5;"R ejected";F2)))))


+-------------------------------------------------------------------+
|Filename: Situation.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4792 |
+-------------------------------------------------------------------+

--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile: http://www.excelforum.com/member.php...o&userid=34309
View this thread: http://www.excelforum.com/showthread...hreadid=543926