If your VAT rate is in cell I1, then in I47 you want the formula
=(I43+I45)*I1, and in I49 you want =I43+I45+I47 [or you could use
=(I43+I45)*(1+I1) ]
--
David Biddulph

"lardy" wrote in message
...
hi
this is my first post so bear with me lol

i have a excel sheet which i want to put in a vat working out and cant get
it to do what i want i can get it to add vat total but that it

i have 2 amounts in I43 and I45 i want to add these 2 together then add
vat
but display only the vat in I47 then add I43 , I45 and vat in I47 and
shown
in I49 can this be done ?

cheers