Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




601 posts

Ultimate Geek
+1 received by user: 26


Topic # 133479 23-Oct-2013 16:19
Send private message

Hi there,

If I perform the following calculation in Excel:
=100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000+50

I obtain
=100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000

This is due to http://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

Is there any Spreadsheet software out there that, when performing =100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000+50, I would obtain 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,050?

I've seen various add-ons to Excel to increase precision, but am curious as if there is any software out there like Excel, so I don't have to mess with commands - keep A1+A2 the same (in comparison with the Xlprecision add-in I would need to type qldadd(A1,A2) - http://precisioncalc.com/What_is_xlPrecision.html. It becomes complex when in a single cell I have additions as well as multiplications occurring (bracketed of course), and don't really want to perform those in a single cell each.)

Many thanks,
Stevie

Create new topic
469 posts

Ultimate Geek
+1 received by user: 107


  Reply # 920485 23-Oct-2013 16:31
Send private message

What sort of work are you doing that requires such accuracy from a spreadsheet application?


gjm

751 posts

Ultimate Geek
+1 received by user: 91


  Reply # 920486 23-Oct-2013 16:32
Send private message

calculating Apple's quarterly profit?




[Amstrad CPC 6128: 128k Memory: 3 inch floppy drive: Colour Screen]

 
 
 
 


118 posts

Master Geek
+1 received by user: 41


  Reply # 920651 23-Oct-2013 20:45
Send private message

100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000

For context, that's about the number of atoms in the universe.

I'm not aware of any spreadsheets that natively handle more than 15 significant figures, though various add-ins will do the job. You mentioned Precision Calc. Another option is Xnumbers, which can handle up to 32760 significant figures.

Conversely, other programming languages can do what you want. For example, Haskell can work with arbitrary precision integers.

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.