Ask Your Question

Can someone please answer this?

asked 2016-06-09 18:04:24 +0200

PaulCRhodes gravatar image

updated 2016-06-09 18:05:41 +0200

I'm using LibreOffice. Why is there a calculating limit? It makes me annoyed. Once I get to a point of numbers, it just gives me a strange thing, but not the result. I have to resort to internet calculators to multiply up. Before you ask, I am calculating high numbers to keep accurate on things. It annoys me that I can't use LibreOffice as the numbers go higher and higher as the thing it's done for, goes on. What am I supposed to do? I can't permanently use Web Calculators, because I have to re-enter it each time and I can't decrease the multiplication by number, because it's a set amount. Even then, I suspect they have their own limits.

edit retag flag offensive close merge delete


What is this "strange thing" you mention? If it shows ### you need to make the cell wider. If it switched to 1E+11 format then again try making the cell wider, or change the cell number format.

What number range are you trying to use?

mark_t gravatar imagemark_t ( 2016-06-09 19:13:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-06-09 19:06:39 +0200

horst gravatar image

All spreadsheet programs I know use only 64-bit floatinhg point numbers. This gives you 15 digits of accurate value after that they are just truncated.

If you can extract part of the number (e.g. large mean value in statistical calculation) you are fine otherwise you will be stuck with internet calculators.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-09 18:04:24 +0200

Seen: 32 times

Last updated: Jun 09 '16