It does for me. Isn't your 3rd column G3? What answer are you getting from
my formula when the E3 and F3 are zero?
--
David Biddulph

"Angela B" wrote in message
...
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!?