| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
writing a formula to distinguish a letter and a number
How do a write a forumla so that is the input is a letter, then look up
values in a table. If the input is a number, than just accept the number. example: Table: a=1 b=2 c=3 Formula; if input = a, then look up the value of a in a table, which is 1 if input =9, then just keep the input 9 as the result |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| formula converting number to column letter 26 | Excel Worksheet Functions | |||
| Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Threaded Mode
