How to increase decimals numbers precision in Sheets formula?

by Saturnix   Last Updated May 15, 2018 19:03 PM

This formula

115000*((10000 / 100000)  - (5000 / 115000))

If executed step by step, should yield 6497.5 as a result. Yet Sheets insists to round it at 6500.

enter image description here

Increasing the cell decimals numbers simply change the result from 6.500,00 to 6.500,000, 6.500,0000, and so on...

This error persists even if I create a column to hold a temporary result: enter image description here

Tags : google-sheets

Related Questions

Copying values between google sheets

Updated July 26, 2018 21:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM