How Excel & ACCPAC calculate formulas?????

[sunshine]

Hi All;

I have been banging my head over this one for quite a while.

I have to generate a daily report in Excel based on Data from an ACCPAC report on the prior days sales and accounts receivable.

When I enter the data from the ACCPAC report, I sometimes get different totals. I am almost always out by a penny or so if I have to add 2 figures to get the subtotal. (I know, not really a big deal but it is annoying to have to type in some of the entries manually in order to make the end result corrct.)

I assume it must in in how far in depth Excel calculates it's functions but I can't find where I would change that setting. I tried using the "predision as displayed" but that did not work either.

My spreadsheet is using the following formula to calcuate tax: =E33*1.15. The only other funtion I am using is the =SUM(G8:G36).

I would very much appreciate any feedback on this issue.

I am using Excel 2002 and ACCPAC Plus Version 6.1.

 

[MrActuary]

You are not rounding the EXCEL calculated values to the nearest penny so the extra digits are being carried through in the summation.

Instead of E33*1.15, try ROUND(E33*1.15,2)

 

[sunshine]

MrActuary. Thank you soooooo much!

Cheers!
Sunshine