| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating a sum of various lenght
I want to be able to place a word and assign a value to it according to the
position of its letters in the alphabet. ie ONE = 15 for O + 14 for N + 5 for E = 34 TWO = 58 I have developed the formula SUM(FIND(MID(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14, 15,16},1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))-(16-LEN(A1)) is there some way to modify it so it says sum(find(mid(a1,{1..len(a1)},1) Alan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| not calculating formulas | Excel Discussion (Misc queries) | |||
| calculating SUM with two conditions | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Threaded Mode
