Calculate VAT

[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

 

[Peo Sjoblom]

Try something like

=C35*(1+C36)

or hardcoded

=C35*1.175

format result as currency


Regards,

Peo Sjoblom

 

[Mark]

Hi,
Fill c35,c36 and write follow formula in c37:
=c35*(1+C36)
Regards
Mark

 

[Bob Phillips]

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)

 

[Alan]

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,