loading...

Discussion on: How-to Avoid Rounding "Errors" in Excel

Collapse
paddy3118 profile image
Paddy3118

DON'T USE A SPREADSHEET.
If you used Python, for example, you could use decimals and set the precision appropriately.

Collapse
calvinpak profile image
CP Author

I agree, Python is amazing for dealing with numbers! While this is true for developers, we often get the requirements from the business people/product managers and they put the samples in Excel. 🤷‍♂️

Collapse
paddy3118 profile image
Paddy3118

Then archive their concept and deliver a solution in a less error prone programming language rather than patching up a buggy, flashy spreadsheet. We had inaccurate Covid 19 stats in the UK due to Excel errors lately, but the horrors are many, and usually buried by companies to save their embarrassment.