Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate Amount of Sales Tax from Total Amount?
I need to create an Excel Formula that calculates how much tax was paid
within a total amount. example: Total Amount = $546.20. Tax base = 8.8%. How much of the $546.20 is tax? |
#2
|
|||
|
|||
Mike,
In principle, you multiply by the tax rate, and divide by 1 (Or 100%) plus the tax rate. So here bit would be =A1*.088/(1+.088) or =A1*8.8%/(100%+8.8%) You might want to round it to 2 dec places as it is currency =ROUND(A1*8.8%/(100%+8.8%),2) -- HTH RP (remove nothere from the email address if mailing direct) "MikeS" wrote in message ... I need to create an Excel Formula that calculates how much tax was paid within a total amount. example: Total Amount = $546.20. Tax base = 8.8%. How much of the $546.20 is tax? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
I want to add 6% sales tax to the amount in a cell/column | Excel Discussion (Misc queries) | |||
How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
Help with Commission forumlas | Excel Worksheet Functions |