View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Extreme calculations

You need to build your own math algoritm in strings. It is not really that
hard, just requires a little bit of time (about 2-3 hours).

The code for multiplying would look something like the code below. You'll
need to call the multiplying routine 271 times. Then write a similar divvide
functtion.

Function multiply(parm1 as string, parm2 as string)

Total = ""
carry = 0
for i = 1 to len(parm1)
mychar1 = right(parm1,i)
for j = 1 to len(parm2)
mychar2 = right(parm2,i)

prod = (val(mychar1) * val(mychar2)) + carrruy
carry = int(prod/10)
remainder = prod mod 10
total = format(remainder,"text") & total
next j




"Diogo" wrote:

no good

but thanks anyway...

Could someone help?

"Joel" wrote:

You need an exponentiator. Look at this website

http://www.math.temple.edu/~reich/numthy/ModExp.html

"Diogo" wrote:

Need to calculate via Excel:

mod(13^271;162653)

Any thoughts????

Thanks