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:
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:
By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.
Feb 26, 2008 |
Microsoft Excel for PC