Clean It Up

UK Floor Cleaning Forum => Carpet Cleaning Forum => Topic started by: lee_gundry on September 28, 2005, 01:14:06 pm

Title: please help
Post by: lee_gundry on September 28, 2005, 01:14:06 pm

does anyone know the formula, to use in ms excell, to add VAT to a given number??

Thanks
Lee G

Title: Re: please help
Post by: poles apart on September 28, 2005, 01:21:56 pm

Lee
I use the simple formula *17.5%. e.g. if the amount is in cell c8 then in d8 type =c8*17.5% that will give you the vat amount. For the total, in e8 type =c8+d8 and this will give the total inc vat. Get back to me if your stuck.
Rod

Title: Re: please help
Post by: lee_gundry on September 28, 2005, 01:28:43 pm

thanks rod

i have entered the formula in the spread sheet & works fine


thanks again

Lee g

Title: Re: please help
Post by: Kinver_Clean on September 29, 2005, 08:05:03 am

Going the other way about- if you multiply the full amount by .148936 it will give you the amount of vat in the total amount. If you look at a calculator keypad the no are in sequence round the pad except for 36 being the other way round.
Just another bit of useless info.

Trevor

Title: Re: please help
Post by: Elite (Ben) on October 01, 2005, 11:14:04 am

to find the amount including VAT multiply by 1.175

ben

Title: Re: please help
Post by: ABLECLEAN on October 02, 2005, 05:08:10 pm

Another way to find the vat content of a total is to divide by 47 and then multiply by 7

 :) ;) :D ;D 8) ::) :P :-*