Excel function to calculate numerology number


Function below to calculate the numerology number (reduced to 2 digits) for a name in Excel:

=SUM( 1* CHOOSE( CODE( MID( LOWER(A1); ROW( INDIRECT("1:" & LEN(LOWER(A1)))); 1))-96; 1; 2; 3; 4; 5; 6; 7; 8; 9; 1; 2; 3; 4; 5; 6; 7; 8; 9; 1; 2; 3; 4; 5; 6; 7; 8))

Press Ctrl+Shift+Return to have Excel treat it as an array function (it will enclose it in curly braces { and }).  A1 is the cell reference containing the name.

  1. #1 by c on November 9, 2012 - 12:10 am

    i get an error. text argument of MID. excel pro 2010

  2. #2 by c on November 9, 2012 - 12:28 am

    the following code worked:
    http://answers.yahoo.com/question/index;_ylt=AqcrYgDarUlcBEswcB.9TfXsy6IX;_ylv=3?qid=20080512111556AAXXeHE

    but only if my word was all lowercase, if it had an uppercase i got a #VALUE error

    i then used =MOD(I1-1,9)+1 to break it down to a single digit

  3. #3 by chandrasegaran on July 15, 2016 - 4:03 pm

    c :
    the following code worked:
    http://answers.yahoo.com/question/index;_ylt=AqcrYgDarUlcBEswcB.9TfXsy6IX;_ylv=3?qid=20080512111556AAXXeHE
    but only if my word was all lowercase, if it had an uppercase i got a #VALUE error
    i then used =MOD(I1-1,9)+1 to break it down to a single digit

(will not be published)


css.php