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
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 28, 2014 | Computers & Internet
Jul 20, 2011 | 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
Jul 23, 2013 | Microsoft Excel for PC
95 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: