|
-
Jul 9th, 2007, 06:44 PM
#1
Thread Starter
Lively Member
more than 16 digits
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
-
Jul 10th, 2007, 10:53 AM
#2
Fanatic Member
Re: more than 16 digits
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
-
Jul 10th, 2007, 02:46 PM
#3
Thread Starter
Lively Member
Re: more than 16 digits
I think the activex dll is to slow for this job is there any other way?
-
Jul 10th, 2007, 09:34 PM
#4
PowerPoster
“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha
-
Jul 12th, 2007, 12:49 AM
#5
Re: more than 16 digits
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)
The time you enjoy wasting is not wasted time.
Bertrand Russell
<- Remember to rate posts you find helpful.
-
Aug 9th, 2007, 10:10 PM
#6
Banned
Re: more than 16 digits
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|