Thread: Mod Function
View Single Post
  #7  
Old December 1st, 2007, 01:18 PM posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
external usenet poster
 
Posts: 491
Default Mod Function

If you are still having difficulties with the calculations, consider
bypassing the internal pecision limitations.

A couple of Excel add-ins that have mod functions and support user specified
numeric precision are
http://digilander.libero.it/foxes/index.htm
http://precisioncalc.com/

You also might consider the free algibraic calculator Maxima
http://maxima.sourceforge.net/

Jerry

"Diogo" wrote:

Dana, thanks you putted me in the right direction, found this code on the net.

....
This works good for numbers that are easly decomposed in 10th powers, but
what about strange numbers like mod(13523456273456;97). It's difficult to
decompose it without loosing significant decimal places along the way. Any
thoughts?
Thanks.