Harlan - Could use some help please, cheers.

  • Thread starter Thread starter Ken Wright
  • Start date Start date
K

Ken Wright

Hi Harlan - I'm trying to work out the significance of a specific number within a formula in an
old post of yours. The formula was for a numerology calculation where you collapsd a number by
summing the digits till you got down to 1 digit, with the exceptions of 11 and 22, and is as
follows (link attached as well):-
and this reduces to 1..9, 11 or 22 with this formula in A4
=MOD(A3-1,IF(MOD(MOD(A3-1,27)+1,11)=0,27,9))+1
Click to expand...

http://www.google.com/groups?threadm=eJkQrZlY$GA.395@cppssbbsa05

I know it works, and I'm OK with the 11s and 9s, but I just can't get my head round the 27. There
are 27 numbers in the Hebrew alphabet, but that didn't help me. It had to be between 22 and 32 to
cover 11 and 22 (But that was purely from trial and error). This is bugging the life out of me -
Any chance you could put me out of my misery, cheers :-)
 
Hi,

There are only 26 Upper letters in the alphabet.
Substracting each letter by the code("A") will generate only number from 0
to 25.
Or 1 to 26 if you add 1 to them.

MOD(N,27) will always output N , (when 0>=N>27)
So, 27 is the first big enough number than will NOT change N in the MOD
function.

As per requirements, the algo should NOT change N when it is 11 or 22.
Harlan tested this by the following test : MOD(N,11)=0,
If true, use 27 as the MOD second argument (thus leaving N as is, as per
requiremetns)
If false, use 9 as the MOD second argument (as required per the algo. BTW:
MOD(N-1,9)+1 is a clever way of adding up individual digits of a two digits
number).

Regards,

Daniel M.
 
...
...
MOD(N-1,9)+1 is a clever way of adding up individual digits of a two digits
number).
Click to expand...
...

It works with any positive integer. This is related to the fact that the sum of
the decimal digits of multiples of 9 are multiples of 9. One of the classic
first week homework problems in introductory Number Theory courses.
 
Harlan,

Thanks for the info (generalisation to all positive integers).
I'm still learning every day, I guess. :-)

Regards,

Daniel M.
 
Back
Top