Calculate Tax

  • Thread starter Thread starter Meerkat
  • Start date Start date
M

Meerkat

Hello all
I'm very new to all this and especially to using Excel 2000 and I really
only know the basics of the program.

I'm creating an invoice for myself and would like it to calulate the VAT for
me from my Total

ie:
C35 is the total excluding VAT
C36 is the VAT at 17.50%
C37 will be the total including the VAT

Can anyone direct me as to what I need to do, to achieve the above?
Thanks in advance for any help
David
 
try to type in what is inside [ ] for example:

C35 [100]
C36 [=C35*17.5%]
C37 [=C35 + C36]
 
See response to previous post.

--

HTH

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