Forum Discussion
PSPAUL
Jul 05, 2019Copper Contributor
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...
Twifoo
Jul 05, 2019Silver Contributor
You CHOOSE this formula instead:
=CHOOSE(MATCH(F11,
{“Distinction”,”Merit”,”Pass”}),
9,8,7)*E11
=CHOOSE(MATCH(F11,
{“Distinction”,”Merit”,”Pass”}),
9,8,7)*E11