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
Printable View
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
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
I think the activex dll is to slow for this job is there any other way?
What did you mean slow.
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)
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.