 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006Ranking 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,F3>=1),E3,IF(F3>1,F3,G3))))) but this is not quite right!! please please can anyone help!? Isn't it just =IF(E3=1,E3,IF(F3=0,G3,F3)) ?  SignatureDavid Biddulph >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 [quoted text clipped - 14 lines] > > please please can anyone help!? hiya thanks for helping. however this doesn't carry over the 3rd column to become the final mark if the first 2 are 0... > Isn't it just =IF(E3=1,E3,IF(F3=0,G3,F3)) ? > >I have to rank a range of exam marks based on frequency of grades. [quoted text clipped - 15 lines] > > > > please please can anyone help!? 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? SignatureDavid Biddulph > hiya > thanks for helping. [quoted text clipped - 24 lines] >> > >> > please please can anyone help!? it works in all respects except for where a 1 occurs in the first column (e3) and a 2,3,4 or 5 occurs in the second (say F3). i need the mark of 1 in the first to override all other outcomes, but it is giving me a 2 etc. (the f3 result) in the final mark. Hope this makes sense thanks again, > 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? [quoted text clipped - 26 lines] > >> > > >> > please please can anyone help!? No it doesn't make sense. Again it works for me. When I have a 1 in cell E3, I get a value of 1 as the result. Are you convinced that you've got a 1 in E3 and that your formula is the same as mine? Exactly what values do you have in E3, F3, and G3, and what result do you get from my formula? Have you got in E3 something which isn't actually numerically equal to 1, either because it is text, or because it is the result of a calculation which gives something close to 1 but not equal to 1? SignatureDavid Biddulph > it works in all respects except for where a 1 occurs in the first column > (e3) [quoted text clipped - 42 lines] >> >> > >> >> > please please can anyone help!? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.