How do I add V.A.T (Value Added Tax) to a spread sheet?
 

Hi, i have been trying to setup a spread sheet for my boss and he want V.A.T
adding to it, and i can't work out how to do this. Can anyone help?

=A1*(1+17.5%)

where A1 is an amount,

Or store the rate, 17.5%, in a cell and use that

=A1*(1+M1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Crusty" wrote in message
...
Hi, i have been trying to setup a spread sheet for my boss and he want
V.A.T
adding to it, and i can't work out how to do this. Can anyone help?

Thanks very much! a great help. Get this thing sorted in no time now!

"Bob Phillips" wrote:

=A1*(1+17.5%)

where A1 is an amount,

Or store the rate, 17.5%, in a cell and use that

=A1*(1+M1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Crusty" wrote in message
...
Hi, i have been trying to setup a spread sheet for my boss and he want
V.A.T
adding to it, and i can't work out how to do this. Can anyone help?