Calculation using alphabet instead if number

nazim - Nov 7, 2017 at 03:59 PM - Latest reply: xpcman 19167 Posts Wednesday October 8, 2008Registration dateModeratorStatus August 16, 2018 Last seen
- Nov 7, 2017 at 04:29 PM
Hello,

Dear Sir,
If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0
For example
Numeric column > 9949 = JJDK <English Letter column
Numeric column > 9949 = JJDK <English Letter column
TOTAL Numeric column >19898 =AJIJI <TOTAL English Letter column
HOW CAN I CALCULATE THIS USING FORMULA IN MS EXCEL
Waiting for your great replay sir thanks a lot sir. Thank you very much sir


See more 

Your reply

1 reply

xpcman 19167 Posts Wednesday October 8, 2008Registration dateModeratorStatus August 16, 2018 Last seen - Nov 7, 2017 at 04:29 PM
0
Thank you
this sounds like a school problem.


Sorry we do not solver your school assignments for you.
Respond to xpcman