Forum Discussion
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...
Paul, back to original formula - if you copy/paste some sample from the web and after that adjusted it to your need, with pasting most probably apostrophe “ CHAR(147) instead of " CHAR(34). Excel doesn't recognize first one as apostrophe and returns #NAME! error. If correct that like
=E11*IFS(F11="Pass", 7, F11="Merit", 8, F11="Distinction", 9, TRUE,0)
As usual in Excel you may use different approaches to receive the same result. Variants are in previous posts, one more for the collection could be
=E11*IFERROR(LOOKUP(F11,{"Distinction","Merit","Pass"},{9,8,7}),0)
Hello Thank you all for your help, the apostrophe was the issue.
Thanks again!!
PSPAUL , you are welcome. In general, be careful with copy/pasting from Web. Most common issues are wrong apostrophes and not printable characters added.