With values in I43 and I45 enter these in I47 and I49

=SUM(I43:I45)*0.1 where vat is 10%

=SUM(I43:I47)


Gord Dibben MS Excel MVP

On Sun, 4 Nov 2007 10:23:01 -0800, lardy
wrote:

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