DECIMALS IN CALCULATIONS CAUSE TOTALS TO NOT MATCH

Rhonda_Reid  wrote:  ``I don't want to lose the mathematical rounding up/down occurring``

But it sounds like that is, in fact, what is happening.

In the calculation worksheet, Excel displays rounded results.  But the actual cell values are unrounded.

The dependent formulas use the unrounded cell values.

-----

For better answers, provide concrete examples of data and formulas.  Ideally, attach an example Excel file, or post a link to an Excel file that we can download.  Of course, the Excel file should be redacted of any private information (names, tax IDs, etc).

In order to achieve what-you-see-is-what-you-get results, you need to explicitly round calculations in each cell -- at least, each cell whose displayed value is copied to grantor's worksheet.

For example, instead of =A1*B1 + C1, write =ROUND(A1*B1 + C1, 2).

And that assumes that each of A1, B1 and C1 either contain constants (123.45) or formulas that are explicitly rounded.