(08-22-2009, 09:52 PM)mmammel Wrote: (08-22-2009, 06:52 PM)spukrian Wrote: Well, Excel is limited to about 15 digits,
You can just do MOD 9 on EACH value that you calculate in the fibonacci sequence -- you don't need to let the sum get large. in excel you could put the seeds in A1 and A2 then in A3 put:
=MOD(A1+A2,9)
Then just copy that formula down the whole column.
Haha, was it as simple as that? *smacks forehead* :redface: Thanks.
EDIT: Well, some of the letters aren´t correct by this method. Not that it matters though, since you could figure out the right letter... (and I had already calculated the right one in most cases). I guess no method is perfect.
Actually now I see that this method sometimes return a zero... which is impossible using the calculating method. This is why some letter aren´t correct.
EDIT: Hehe, just realized that everytime this produces a 0 it should be 9 instead *smacks forehead again* :redface: