How do you calculate VAT on a spreadsheet?

I need to calculate VAT on a spreadsheet and must use a cell that is formatted to % at 17.5%. The value of the item is in cell E5, the 17.5% is in cell F3 and the VAT amount should be in cell F5

I'm a a recently self employed flooring fitter (sole trader), I only have very simple accounts with income from jobs paid on completion and only a few expenses for tools and consumables etc each month. I currently have a spread sheet set up to keep tabs...

I want to know how much profit I make on a product, taking into account buying and selling vat costs, vat on courier etc. Can anyone give me the correct spreadsheet cells and formulae for the following example :- cost of product to me £11.16 ex...

Hi. I sell some products on Amazon and have a mixed set of figures (some include VAT, others do not) to work with. I need to work out if my products are profitable or not. Here's a typical set of values: + Sale Price (incl. VAT): £49.95 - Cost...

How do i calculate the VAT refund with 20%? Before i used to divide by 6.7142 to calculate the 17.5%??

selling price 300 vat 17.5 % settlement discount 3 % how to calculte vat ? if trade dicount is given den we subtract vat value from net price but in settlement discount we subtract vat value fron net seeling price

For example, if you have a bottle of Pepsi with MRP Rs 25, and the VAT rate on soft drinks is 20%, what is the VAT actually paid by the consumer?

http://www.vatcalculator.org.uk/ this site lets me enter a amount e.g £100 and it will calculate vat and give me £120 how do i do the reverse??? i want to enter eg in £120 and i want to get back £100 ] which site lets me do this...