Ask Your Question

Cells won't calculate based on whole numbers

asked 2017-04-25 10:02:33 +0200

AudreyBillings gravatar image

Hi so I'm loving LO for the most part but I'm having an issue. I'm trying to build a continual reinvestment formula that's based on whole numbers of parts… there's no such thing as 2.28 widgets but my spreadsheet is spitting out capital costs based on fractions of parts purchases. I reduced the number of decimal places in the formatting to zero and it changes it visibly but not the behind-the-scenes math. Any help whether through format tweaking, logic, or any other solutions would be greatly appreciated.

edit retag flag offensive close merge delete


Thank you for your help! All of a sudden my profit forecast is… slightly less rosy actually 😅

AudreyBillings gravatar imageAudreyBillings ( 2017-04-25 10:47:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-04-25 10:30:55 +0200

The easiest thing is to set "Precision as shown" on Tools->Options->LibreOffice Calc->Calculate. The other option is using rounding throughout your calculations...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-25 10:02:33 +0200

Seen: 26 times

Last updated: Apr 25 '17