| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to give a Numeric Value to a text grade.
Please see attached image. You will see I have a document, which I have to give a text grading Good Acceptable etc. However each of these grades have a value which has to be entered in the total. Therefore I would like to know how to give a score to each text in the drop down list. After I select the grade the score then adds up in the total box. As currently I add the score up manually then add it into the total.
You assistance is greatly appreciated. Thank You. Last edited by neilwill1979 : November 15th 10 at 02:48 PM Reason: More description |
|
#2
|
|||
|
|||
|
Quote:
__________________
Asobi Wa Owari Da Last edited by wickedchew : November 17th 10 at 05:21 PM Reason: Forgot something... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I give a word a numeric value?? | Excel Discussion (Misc queries) | |||
| I give up, trying to sum with non numeric cells. | Excel Worksheet Functions | |||
| How can I give text a changeable numeric value? | Excel Worksheet Functions | |||
| give text a dollar numeric value | Excel Worksheet Functions | |||
| I would like to use function to give car allowance for grade D on. | Excel Discussion (Misc queries) | |||
Hybrid Mode
