Forum Discussion
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...
Excel calculates correctly.
The "issue" is you probably formatted the cell with 2 decimals, but the underlying numbers probably have more decimals.
The "issue" is you probably formatted the cell with 2 decimals, but the underlying numbers probably have more decimals.