When you have a fraction in Excel like 1.085 rounded to two decimals = 1.09.
In Excel if you add a series of these fractions with displayed two decimals of precision you are really adding 1.085 and not 1.09. The problem is that Quickbooks is using 1.09. That means calculations in Quickbooks and Excel accumulate differences.
Mathematically Excel is correct. But for accounting purposes I need to do what Quickbooks does.
The question - how do I get Excel to ACTUALLY round to two decimals of precision and use that number in the subsequent calculations like Quickbooks does?