How Excel & ACCPAC calculate formulas?????

sunshine

New Member
Joined
May 27, 2003
Messages
32
Hi All;

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

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.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

MrActuary

Board Regular
Joined
Jun 18, 2004
Messages
73
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,539
Messages
5,596,754
Members
414,097
Latest member
FaeFen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top