Geekzone: technology news, blogs, forums
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:

I obtain

This is due to

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) - 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,

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?


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


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.