Forum Discussion
Ninram
Mar 02, 2024Copper Contributor
Results differ when pointing to a calculated cell using decimals.
I am working on a spreadsheet to work out yearly salary over time. I have a cell with this formula: =A1*8*260 If A1 contains 8.01 then the formula returns the correct answer of 16661 If A1 contain...
PeterBartholomew1
Mar 02, 2024Silver Contributor
It is just rounding error. Show more decimal places for each of your numbers and you will see that the values and the calculations based upon them are slightly different.