Re: Ranking exam marks
- From: "David Biddulph" <david@xxxxxxxxxxxxxxx>
- Date: Tue, 7 Nov 2006 15:40:07 -0000
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" <AngelaB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:59B8E39A-FB74-41BE-B9C8-F9D4078A0E2F@xxxxxxxxxxxxxxxx
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" <AngelaB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4E88208-04AB-43E7-8054-60A4BEEC9DC6@xxxxxxxxxxxxxxxx
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,F3>=1),E3,IF(F3>1,F3,G3)))))
but this is not quite right!!
please please can anyone help!?
.
- References:
- Re: Ranking exam marks
- From: David Biddulph
- Re: Ranking exam marks
- Prev by Date: Re: conditional sum query
- Next by Date: Re: How to create a copy of a folder having five files in it, & rename
- Previous by thread: Re: Ranking exam marks
- Next by thread: Re: Ranking exam marks
- Index(es):
Relevant Pages
|
