Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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.
Attached Images
 

Last edited by neilwill1979 : November 15th 10 at 03:48 PM Reason: More description
  #2   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by neilwill1979 View Post
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.
See the picture attachment. Then for the TOTALS, C8 =SUM(C3:C7)
Attached Images
 
__________________
Asobi Wa Owari Da

Last edited by wickedchew : November 17th 10 at 06:21 PM Reason: Forgot something...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I give a word a numeric value?? Liz Excel Discussion (Misc queries) 2 June 23rd 08 12:59 AM
I give up, trying to sum with non numeric cells. [email protected] Excel Worksheet Functions 2 June 20th 08 08:53 AM
How can I give text a changeable numeric value? Steve_Dallas Excel Worksheet Functions 3 October 2nd 07 11:47 PM
give text a dollar numeric value Gav Excel Worksheet Functions 6 June 5th 07 01:57 PM
I would like to use function to give car allowance for grade D on. Masoom Al-Omran Excel Discussion (Misc queries) 1 May 23rd 05 08:40 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"