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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,126,986
Messages
5,621,990
Members
415,872
Latest member
ReignEternal

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