So, with C2 = Net, D2 = VAT, & E2 = Total, & where you are starting with the Total -
C2 = E2/1.175
D2 = E2-C2
E2 = Whatever you enter
---------- Post added at 00:35 ---------- Previous post was at 00:34 ----------
Quote:
Originally Posted by louise1989
lock both the cell then protect sheet ????
---------- Post added at 00:33 ---------- Previous post was at 00:31 ----------
To matt d
I hope that wasnt too me because you might as well spoke french !!
|
It was to rogerdraig, because the net price, when VAT is 17.5%, isn't simply 82.5% of the final price.
EDIT:
VAT of 17.5% -
VAT = 17.5% of the net price = net price * 0.175 [17.5/100=0.175]
So, the total price (net + VAT) = net price *
1.175 [Multiplying by 1 plus VAT]
To work backwards from a final price, and find the net price excluding VAT, you divide by 1.175 instead of multiply by 1.175:
Net price = Total price / 1.175
VAT of 20% -
0.2 instead of 0.175, so you multiply the net by
1.2 to find the total, or divide the total by
1.2 to find the net.