Forum Discussion

PSPAUL's avatar
PSPAUL
Copper Contributor
Jul 05, 2019

Help with IFs formula needed

  I have tried lots of different formulas from websites and adapted them but none work.  All i want to do is using a drop down select a grade for a specific unit/module eg Pass, Merit or Distinction...
Formulas and Functions
PSPAUL's avatar
PSPAUL
Copper Contributor
Jul 05, 2019
I have done some more digging and when i replace the words with numbers and not using a drop down it works, does anyone have any suggestions on how I can get my version to work?

Many thanks

  • Gemma Telfer's avatar
    Gemma Telfer
    Copper Contributor
    Jul 05, 2019

    PSPAUL 

    Hi Paul

     

    If you try this formula, I think it works

    =IF(F11="Merit",8+E11,IF(F11="Pass",7+E11,IF(F11="Distinction",9+E11)))