How Excel & ACCPAC 6.1 calculate formulas????

[Bass Mama1]

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!

[Bass Mama1]

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!
>