PDA

Click to See Complete Forum and Search --> : more than 16 digits


BlackCatSLO
Jul 9th, 2007, 06:44 PM
Hy there.
I have question i dont know how i can calc values with more than 16 digits
So i can calc PI or sqr of 2 and other things with more than 16 digits.

tnx for help

VBAhack
Jul 10th, 2007, 10:53 AM
There is a multi-precision Excel add-in called XNUMBERS that can make calculations up to 250 significant digits. It is also available as an ActiveX DLL. The documentation is excellent.

http://digilander.libero.it/foxes/index.htm

BlackCatSLO
Jul 10th, 2007, 02:46 PM
I think the activex dll is to slow for this job is there any other way?

eranga262154
Jul 10th, 2007, 09:34 PM
What did you mean slow.

jemidiah
Jul 12th, 2007, 12:49 AM
The only way I've ever heard of working with larger precision is to use arithmetic on strings where you'd have to write your own functions that give precision to your desired level. Maybe there's another better way, or maybe this way can be optimized like mad, but I'm sure that in any case writing a general n-digit precision calculator is tough and relatively slow.

Maybe that will give you a little bit of direction in searching (maybe not)

learning c
Aug 9th, 2007, 10:10 PM
try the decimal datatype if the app is already built and you need extra precision. you're right tho... you can build your own calculator engine to handle large numbers except it would be slower than inbuilt functions... so if speed is required stick with native datatypes otherwise a custom solution is a possibility.