Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to try to create a formula to convert numbers to letters using the
following scale: 0 = A 1 = B 2 = C 3 = D 4 = E 5 = F 6 = G 7 = H 8 = I 9 = J Such that 12.34 would be transformed to BCDE. This is the formula I had tried, but it won't accept: =CONCATENATE(HLOOKUP(RIGHT(ROUNDDOWN(M2/10000,1),1),A1:J2,2),HLOOKUP(RIGHT(ROUNDDOWN(M2/1000,1),1),A1:J2,2),HLOOKUP(RIGHT(ROUNDDOWN(M2/100,1),1),A1:J2,2),HLOOKUP(RIGHT(ROUNDDOWN(M2/10,1),1),A1:J2,2),HLOOKUP(RIGHT(ROUNDDOWN(M2,1),1) ,A1:J2,2),HLOOKUP(RIGHT(ROUNDDOWN(M2*10,1),1),A1:J 2,2)) M2 is my starting number and the table array is the Number/Letter Conversion Chart. I truly hope someone can help me. Thank you, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with parameter substitution in formula (&value), vbScript | Excel Worksheet Functions | |||
variable substitution in a formula linking to external workbook | Excel Discussion (Misc queries) | |||
variable substitution in a formula | Excel Discussion (Misc queries) | |||
Cell Formula substitution. | Excel Discussion (Misc queries) | |||
why does ON = Ambiguous in substitution formula? | Excel Worksheet Functions |