Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MikeS
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate total interest earned on a loan and monthly payment Matt Stanley Excel Worksheet Functions 4 May 4th 23 03:42 AM
formula to calculate sales tax from total sales Deanna Excel Worksheet Functions 7 October 5th 05 08:57 PM
I want to add 6% sales tax to the amount in a cell/column Bobb1220 Excel Discussion (Misc queries) 3 March 12th 05 02:58 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 03:33 AM
Help with Commission forumlas asdfasdf Excel Worksheet Functions 6 November 15th 04 06:28 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"