I have a problem with a spreadsheet. I have a tax rate, a constant .062, in column M.
I multiply the rate by a number in an adjacent column, whose value ends up at 1192.82 (the result of a chain). The result, about 73.96, shows properly if the column M is formatted to THREE decimals. HOWEVER, if I format the column as TWO decimals, the 73.96 shows as 71.59, (also affected by how I format column L) which surprises me. I would understand showing as 73.96 or 73.95 but 71.xx is just wrong. I cannot reproduce this in a super simplified spreadsheet of 4 cells, so I pared out some irrelevant calculations.
It’s a financial sheet, must I use 5 decimals? 6? I’m afraid many formatting choices on the starting cells are affecting the final results.
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Paycheck-remake-trial.ods (13.7 KB)