I need to know a function that i can for excel.
i will use it for scoring.
say for example:
a = 3
b = 2
c = 1
d = 0
is there a function that I can use to do this? I will be using at least 5 categories. please help me.
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
130 views
Usually answered in minutes!
please help me create the function
×