P
Peter
able?Hi:
I am trying to modify the "Price quote with tqx calculation" template. We
have 2 sales taxes. The first tax is calculated as a % of the total sales+Tax
1. I need to show each tax separately, then total them.
The Quote template has a column "Taxable?" (Column E) The tax is calculated
only on the items with a T in Column E.
Cell F31 is Subtotal: =SUM(F22:F30)
Cell F32 is Tax Calculation 1: =7%*SUMIF(E22:E30,"T",F22;F30)
Now I need to calculate Tax 2, which is 7.5% of the (Subtotal + Tax1). i.e.
I need to add the Subtotal and Tax 1, multiply it by 7.5% and show that
result. But, like Tax 1, only for the items with a T in Column E.
I am trying the formula: =7.5%*SUMIF(E22:E30,"T",F31:F32)
but without success:
Any suggestions would be much appreciated.
Thank you.
I am trying to modify the "Price quote with tqx calculation" template. We
have 2 sales taxes. The first tax is calculated as a % of the total sales+Tax
1. I need to show each tax separately, then total them.
The Quote template has a column "Taxable?" (Column E) The tax is calculated
only on the items with a T in Column E.
Cell F31 is Subtotal: =SUM(F22:F30)
Cell F32 is Tax Calculation 1: =7%*SUMIF(E22:E30,"T",F22;F30)
Now I need to calculate Tax 2, which is 7.5% of the (Subtotal + Tax1). i.e.
I need to add the Subtotal and Tax 1, multiply it by 7.5% and show that
result. But, like Tax 1, only for the items with a T in Column E.
I am trying the formula: =7.5%*SUMIF(E22:E30,"T",F31:F32)
but without success:
Any suggestions would be much appreciated.
Thank you.