Question about Microsoft Excel for PC
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:
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.
Posted on Feb 26, 2008
Tips for a great answer:
May 24, 2015 | Microsoft Excel for PC
Jun 28, 2014 | Computers & Internet
Feb 22, 2011 | Computers & Internet
Mar 29, 2009 | Texas Instruments TI-30XA Calculator
Jan 13, 2009 | Computers & Internet
Aug 25, 2008 | Microsoft Office Professional 2007:...
Feb 29, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Usually answered in minutes!
Step 2: Please assign your manual to a product: