# How do I calculate Amount of Sales Tax from Total Amount?

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. ## Re: How do I calculate Amount of Sales Tax from Total Amount?

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" <MikeS@discussions.microsoft.com> wrote in message
news:8BFCF620-A568-44BF-8F51-74906091EE4F@microsoft.com...
> 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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1