Calculate VAT

  • 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 something like

=C35*(1+C36)

or hardcoded

=C35*1.175

format result as currency


Regards,

Peo Sjoblom
 
Meerkat,

In C37, and assuming that the value in C36 is held with a percentage sign

=C35*C36

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi,
One way,
C35 is the total excluding VAT
In C36 use =C35*0.175
In C37 use =C35+C36

If you enter the VAT rate in another cell, say A1, you can use
=C35*A1

Regards,
 
Back
Top