I have created an invoice form that allows for 8 items to be entered on the invoice. My columns are numbered as follows:
A12 = Item Description
C12 = Price per item $1.70
E12 = Quantity of items 75
F12 = 7% Tax 7%
G12 = 5% Tax 5%
H12 = Total of F12*J12 $8.93 if not rounded figure would be 8.925
I 12 = Total of G12*J12 $6.38 if not rounded figure would be 6.375
J12 = C12 * E12 $127.50
K12 = H12+I12 $15.30
L12 = J12+K12 $142.80
My problem is the numbers reported in H12 & I12 are rounded to 2 decimal places. When the total is reported in K12 it uses 3 decimal places and my answer then is not correct.
How do I get K12 to report the correct answer of $15.31
Thanks in advance for any help.
A12 = Item Description
C12 = Price per item $1.70
E12 = Quantity of items 75
F12 = 7% Tax 7%
G12 = 5% Tax 5%
H12 = Total of F12*J12 $8.93 if not rounded figure would be 8.925
I 12 = Total of G12*J12 $6.38 if not rounded figure would be 6.375
J12 = C12 * E12 $127.50
K12 = H12+I12 $15.30
L12 = J12+K12 $142.80
My problem is the numbers reported in H12 & I12 are rounded to 2 decimal places. When the total is reported in K12 it uses 3 decimal places and my answer then is not correct.
How do I get K12 to report the correct answer of $15.31
Thanks in advance for any help.