Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate taxes
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate taxes
If you can do one, do it for 13%
Steve On Thu, 07 Sep 2006 00:24:01 +0100, 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate taxes
Looks like Provincial/State tax and Federal GST
The taxes are not compounded, so just add them together and tack onto the selling price. =A1+(A1*.13) Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 16:24:01 -0700, 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate taxes
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. If you can do one, ostensibly it would seem "obvious" how to do two. It would be helpful if you posted the formulas that you use to compute one, so that we might understand your confusion better and offer some help. For example, if your sale price is in A1 and you can compute the total with 7% tax added in A2 with =A1*(1+7%), you could compute the total with combined 7% and 6% tax with =A1*(1+7%+6%), or do the addition in your head and formulate it as =A1*(1+13%). Since that seems too obvious, I suspect I have over-simplified your problem or how you want to structure the solution. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate taxes
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't get excel to calculate | Excel Worksheet Functions | |||
any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
How do I calculate hours in Excel | New Users to Excel | |||
Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) |