Previous Topic Next Topic

Calculation using alphabet instead if number

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


1 response

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


Sorry we do not solver your school assignments for you.
0

Similar discussions

calculating fuel surcharge
Nancy -
xpcman -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses