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!?