Remember Me?

 MikeS Posts: n/a 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?

 Bob Phillips Posts: n/a 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?

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Deanna Excel Worksheet Functions 7 October 5th 05 08:57 PM Bobb1220 Excel Discussion (Misc queries) 3 March 12th 05 01:58 PM Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM Matt Stanley Excel Worksheet Functions 3 December 22nd 04 05:26 PM asdfasdf Excel Worksheet Functions 6 November 15th 04 05:28 PM

All times are GMT +1. The time now is 03:56 AM. Copyright ©2004-2020 ExcelBanter.