Calc tax

  • Thread starter Thread starter NoOne
  • Start date Start date
N

NoOne

I have the following

Subtotal 12.49
Tax 1.5

Total Tax + sub
I would like to get the total. How would I do that? Would I enter the
percent tax? Can I have a formula that converts the percent tax to a real
number then add that to the total? Thanks In advance for any help provided

Thanks
Geo
 
Hi Geo:
assuming the follwoing:
A1: Your subtotal value
A2: Your tax as percentage

You can use the following formulas:
=A1*A2 -> your tax amount as value
=A1*(1+A2) -> your total amount including tax

HTH
Frank
 
Geo,

Subtotal in A1
Tax in A2, in percent form , that is 1.5%

=ROUND(A1*(1+A2),2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
One way

12.49 in A1, 1.5% in B1

=A1*(1+B1)

or hardcoded

=A1*1.015

you might want to round the result
 
you could have your 12.49 in cell d10, for example.

You can even format that so it reads $12.49 in Format -
Cells - Category - Currency for any cells you want to
have a currency format.

But, let's say you have 12.49 in cell d10.

In d11 you can say =d10*.015

This will take the contents of cell d10 times 1.5%,
or 19 cents.

Then in cell d12 you can say =sum(d10:d11), to get
your total of the two cells.

Dennis in Las Vegas.
 
Back
Top