Forum Discussion
DECIMALS IN CALCULATIONS CAUSE TOTALS TO NOT MATCH
In each section of the calculations worksheet, Expense * % is the formula, formatted to two decimal places. I then must manually key this result into another Excel worksheet (no way around the manual...
If you want your calculation to match the manually keyed values then you would need to introduce small errors to the calculation to round the results
= SUM( ROUND(expense, 2) )
[You might need ROUNDDOWN if your manually keyed values are simply truncated rather than rounding some up]