| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Hi, If you want avoid a table then try this, =LOOKUP(C2,{0,"F";60,"D";70,"C";80,"D";90,"A"}) where C2 houses the score. HTH -- Krishnakumar ------------------------------------------------------------------------ Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138 View this thread: http://www.excelforum.com/showthread...hreadid=465803 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a number value to a letter? | Excel Discussion (Misc queries) | |||
| Convert Social Security text to number? | Excel Discussion (Misc queries) | |||
| how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
| convert number to text in Spanish Language | Excel Worksheet Functions | |||
| How I convert number to word | Excel Discussion (Misc queries) | |||
Threaded Mode
