Hello:

Try this:

Assume that you enter .07 in A1 and .06 in A2 (you can format
them as percents if you wish).

Your before tax prices are in A4 through…..A??
Then enter =A4*(1+$A$1+$A$2) in B4 and copy down to B??
This calculation assume the taxes are independently applied to sale price.

If they are not, as they are in some cases with things like excise taxes,
then you would use the following in B4: =A4*(1+$A$1)*(1+$A$2).
This would produce a larger price.

As to who gets the extra that depends upon the rule. If the 6% tax
includes the 7% tax then the total tax per dollar will be .1342.
With 7 cents going to first tax authority and 6.42 cents going to the second.

Pieter Vandenberg

B.W. wrote:
: I have columns of sale items that need to have two taxes
7% & 6% added to
: them. I can do one by but not sure how to combine them.
ie 100+7+6=113. What
: is the formula for this. I am relatively new to this.