Ms excel function
I'm not entirely sure how you want to use this, but it is fairly easy to automatically assign a value to a cell based on the value in another.
Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score:
=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0))))
You can go on adding as many further 'IF' statements as you like.
You can elaborate on this a bit by changing it to the following:
=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0,"Not Scored"))))
By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.
Matt
×