How Excel & ACCPAC 6.1 calculate formulas????
 

Hello!

I am hoping someone can give me some insight on this problem. I am using
Excel 2002 and ACCPAC 6.1.

When I generate a report based on data in an ACCPAC report the numbers are
sometimes out by a few pennies.

My spreadsheet formulas are to calculate tax =E9*1.15 and =SUM(G8:G36).

I have tried the prescision as displayed but it still wont work properly!!!!

I am sure the problem is in the differences in which ACCPAc and Excel
calculate formulas but I don't know where to go from there.

Any feedback is appreciated.

Many thanks!

I found the answer to my question from a post on the MrExcel.com website.
The formula to correct this problem is:

=ROUND(E8*1.15,2)

Cheers1


"Bass Mama1" wrote:

Hello!

I am hoping someone can give me some insight on this problem. I am using
Excel 2002 and ACCPAC 6.1.

When I generate a report based on data in an ACCPAC report the numbers are
sometimes out by a few pennies.

My spreadsheet formulas are to calculate tax =E9*1.15 and =SUM(G8:G36).

I have tried the prescision as displayed but it still wont work properly!!!!

I am sure the problem is in the differences in which ACCPAc and Excel
calculate formulas but I don't know where to go from there.

Any feedback is appreciated.

Many thanks!