Calculation using alphabet instead if number

Closed
nazim - Updated on Nov 7, 2017 at 04:00 PM
xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 - 7 Nov 2017 à 16:29
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


Related:

1 response

xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 1,824
7 Nov 2017 à 16:29
this sounds like a school problem.


Sorry we do not solver your school assignments for you.