|
Ok got a small problem with a formula and I think my brain has died. Any help will be appreciative. I have three sections that grade the person on a percentage over how much they have completed. Each section is labelled Pass, Merit and Distinction. What I am trying to accomplish is to have a cell on my spreadsheet that gives an overall statement depending on those percentages. So for example: Pass: 100%, Merit: 100% and Distinction: 100% = In this scenario I want the cell to display Distinction. In another example: Pass: 100%, Merit: 50% and Distinction: 100% = I want the cell to display Pass as the person has failed the Merit section so cannot be graded any higher. Now currently this is what I have ended up displaying: code:
CR5 = Percentage for Pass CW5 = Percentage for Merit DB5 = Percentage for Distinction Which does not work. I'm probably missing something really simple here so feel free to call me stupid.
|
# ¿ Jul 26, 2011 19:31 |
|
|
# ¿ May 14, 2024 01:28 |
|
Sub Par posted:You're missing an "else" answer for that last if. I think I'm missing something else. code:
|
# ¿ Jul 26, 2011 20:50 |
|
Scientastic posted:The formula you want is this: Brilliant, I knew it was something along those lines. Thanks for your help.
|
# ¿ Jul 26, 2011 21:24 |