Google Sheets hasn't a way to change the calculation precision. Just look at the options in File > Spreadsheet Settings There isn't any option there for that. [![General][1]][1] [![Calculation][2]][2] Perhaps using Google Apps Script could be an option but you should also be aware of handle this could not be simple if you aren't familiar with floating-point related data types and operations. Related - https://webapps.stackexchange.com/q/80125/88163 (Web Applications) - [More Precise Floating point Data Types than double?](https://stackoverflow.com/q/15659668/1595451) (Stack Overflow) - [How to deal with floating point number precision in JavaScript?](https://stackoverflow.com/q/1458633/1595451) (Stack Overflow) [1]: https://i.sstatic.net/U2opI.png [2]: https://i.sstatic.net/cLRE9.png