Re: Ranking exam marks

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


.

Relevant Pages

  • Re: Ranking exam marks
    ... "David Biddulph" wrote: ... need to display a rank of 1. ... which is a higher grade. ... -so if the first two columns show 0, the third outcome is the final ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Ranking Records in a Select Query
    ... When you actually display the ... records getting the position in the recordset / rank is easy. ... > 1) Displaying a ranking next to each entry (this is a top sellers ... >>> I'm running Access 2002. ...
    (microsoft.public.access.queries)
  • Re: HK - Honor
    ... it does still count in a few places - e.g. the highest ranked player ... will be auto-assigned battleground-leader when they join.) ... and can choose to have this rank displayed in front of your name. ... you can choose to display it. ...
    (alt.games.warcraft)
  • Re: Creating a College Grading system using COBOL
    ... program-id. ... display "The grade is " outputGrade ... move letterGrade to outputGrade ...
    (comp.lang.cobol)
  • Re: Pictures in Forms associated with specific IDs
    ... The way I have it set up is to have one main table with the basic scout ... number (ID number for respective patrol, rank and position). ... that to display so that as I cycle through each boy, ...
    (microsoft.public.access.forms)