Quote:
Originally Posted by Matt D
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)
|
quite right was rushing there should have been
C2 =SUM(E2/117.5)*100
D2 =SUM(E2/117.5)*17.5
was doing it that way to make it easier to understand but then my brain switched off lol ( was laughing at hot fuzz may have been the culprit ther lol )
was using the 17.5 because i think they said thats the value they wanted