Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking exam marks
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!? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking problem | Excel Worksheet Functions | |||
Minimum Exam Score Calculator | Excel Worksheet Functions | |||
Ranking a List which must be within GROUPS | Excel Discussion (Misc queries) | |||
Formula - Marks in Group | Excel Discussion (Misc queries) | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel |