Ranking exam marks
hiya
thanks for helping.
however this doesn't carry over the 3rd column to become the final mark if
the first 2 are 0...
"David Biddulph" wrote:
Isn't it just =IF(E3=1,E3,IF(F3=0,G3,F3)) ?
--
David Biddulph
"Angela B" wrote in message
...
I have to rank a range of exam marks based on frequency of grades.
I have three outcomes in 3 columns which I need to condense into one final
ranking.
-the first condition returns a 0 or a 1, if a 1 occurs this is a fail, i
need to display a rank of 1. If a 0 occurs pass to the next outcome.
-the second condition returns 0 - 5, if the mark is between 1 and 5 I need
the final rank to display that grade 1-5, if an 0 occurs to pass to the
third
condition, which is a higher grade.
-so if the first two columns show 0, the third outcome is the final grade.
So far I have tried to use:
=IF(E3=1,E3,IF(F3=1,F3,IF(E3+F3=0,G3,IF(AND(E3=1,F 3=1),E3,IF(F31,F3,G3)))))
but this is not quite right!!
please please can anyone help!?
|