Sales Tax Spreadsheet formula help

Hello.
I made a spreadsheet for computing sales tax in Pa. I am coming up with different amounts of sale tax when figuring tax on each item and when figuring tax on the total. attached is an example sheet. Rows 2-26 are individual items with the totals in row 28. Row 30 contains tax and price using the total in cell A28. I know that 3 cents is not alot but I think both figures should be exact. I hope I have explained this correctly.

Thank you very much for replies,
Chuck

example.xls

Its because you're rounding to 2 decimal places on each line in one instance and rounding the TOTAL sales to 2 decimal places in the other instance.

Change your rounding to 4 place decimals and you'll see a difference.

How is tax really applied? to each line item or to the sales total?

Carsto:
Each row in the example is a sale to a different customer. I can't charge someone $4.8113 tax. It would still be $4.81.

S0ren:
I really don't get what you mean. In B30 I am rounding on A28. As far as C30 goes, I could subtract B30 from A28 and still get the same figure ($120.28)

Thank you both for the replies
Chuck

replacing the comma with a period

22500.24
-254.24
-22500.24
127.12
127.12

excel gives 0.00 cells formatted as number
calculator gives 0

I must have your example wrong.

Also, when I submit the form online, I enter the total sales (cell A28) $2,125.00 and the form online automatically calculates the tax. In this case it is $120.28 (cell C30). Whereas I only collect $120.25 (cell C28). This is only an example. In actuality over the course of a year it adds up to quite a few dollars.

Thank you,
Chuck

This is a government form.

I'm on Excel 2003

Thanks for the help. I'll leave the thread open. Maybe someone else will chime in.

Thank you very much,
Chuck

Ok. This is sorted out. I was figuring the tax in the wrong way.
Thank you both for the replies.

Chuck