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