Quote:
Originally Posted by rogerdraig
if i get you right your entering the total and want the others to work out ?
if so
put the formula =SUM(E1/100)*82.5 in cell C2
and
put the formula =(E1/100)*17.5 in cell D2
lock both the cell then protect sheet
|
The price excluding 17.5% VAT isn't simply 82.5% of the final price.
With a VAT rate of 17.5%:
Final price / 1.175 = Net price (excluding VAT)
Net price * 1.175 = Final price (including VAT)
e.g. An item costing £100 wouldn't be £82.5 excluding VAT, it would be £85.11
With the current VAT rate of 20%:
Final price / 1.2 = Net price (excluding VAT)
Net price * 1.2 = Final price (including VAT)