I am trying to do some simple calculation in google sheets. Results are not correct when I checked them with the calculator. Problem is with the red border cell.

Editable Sheets link: https://docs.google.com/spreadsheets/d/1tUD0S9ZqMBweaaqaqm7PxUcATuTGJDjZN5CeEpig5Jc/edit#gid=0

CodePudding user response：

29.99 * 1.5 = 44.985 ! the result is correct if you don't round th intermediate value ...

CodePudding user response：

I agree with Mike the issue is the fact that the number is rounded which leads to this issue, basically you are multiplying by 44.985 not 44.99

CodePudding user response：

This is giving right answer. If you will multiply 48,283.33 * 44.9850 then result will be 2172025.60005 only. If you are doing whole calculation (including previous steps in your sheet then this may vary because of some decimal points.