Reputation: 55
I've researched this quite a bit but to no avail, I've tried to do a choose with:
=CHOOSE(MATCH(R5,{"PASS","MERIT","DISTINCTION"},FALSE),"70","80","90")
Alternatively I've done:
=IF(R5="PASS","70"), IF(R5="MERIT","80"), IF(R5="DISTINCTION","90")
The plan is to see what the input would be for the cell R5, if it is pass then the cell that is selected which is U5 would show the appropriate points.
Pass is 70 points, Merit is 80 and a Distinction would be 90 so you can see my reasoning behind the choices in my code. Not entirely sure how to go about it. Also tried using ORs in the IF statement but I might not have coded it in completely correctly.
Upvotes: 0
Views: 112
Reputation: 174990
The Excel IF
statement is defined as:
=IF(condition,value_if_true,value_if_false)
You can substitute the values with additional statements, so it becomes:
=IF(R5="PASS","70",IF(R5="MERIT","80",IF(R5="DISTINCTION","90")))
This is equivalent to the following pseudo-code:
if(R5 equals "PASS"){
"70"
} elseif (R5 equals "MERIT") {
"80"
} elseif (R5 equals "DISTINCTION") {
"90"
}
Upvotes: 2