Calculate Tax

[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

 

[Chip Pearson]

Meerkat,

Use a formula like the following in cell C37:

=C35*(1+C36)

 

[Cole]

try to type in what is inside [ ] for example:

C35 [100]
C36 [=C35*17.5%]
C37 [=C35 + C36]

 

[Bob Phillips]

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)