In Excel, how to automatically write a 3-attempt-exam final result in words?
As in the attachment, using Excel 2007, I have a record of students' marks of 5 lessons (actually they are 15 lessons but I give a sample of 5)
Each student has the right of 3 attempts to pass the exam.
What I'm looking for is, how to let Excel writing the final result of each student in letters.
For example:
Pass in 1st attempt;
Pass in 2nd attempt;
Pass in 3rd attempt; or
Fail.
Please, see the attached file.
Thanks.
|