I use excel a bit, but I am still learning.
Here is the thing I want to try to do:
I have a product that costs X amount I want the said product to have a 35%
total clear profit after VAT.
I want a cell to have the trade price, the next cell to show the VAT for the
trade price, A cell to show the selling price (with the mark up), a cell
with the VAT for the selling price and finally a cell where I could set the
mark up value in percents. So if I change the percent value in the percent
cell it shows a different value in the selling price?
I wondered if anyone could help me with this?
Any help would be gratefully accepted.
NIK
Franksta - 16 Apr 2007 15:40 GMT
Kinda hard to illustrate but I think this is it. this is the formula that I
have used.
A2 = Trade Price
B2 = VAT %
C2 = Trade Price + VAT%
D2 = Markup %
E2 = Markup Price
F2 = Markup +VAT
formula for C2 is =A2+(A2*B2)
formula for E2 is =A2+(A2*D2)
formula for F2 is =E2+(E2*B2)
At least, that is what I think I understand from your question. Hope that
helps.
>I use excel a bit, but I am still learning.
>
[quoted text clipped - 14 lines]
>
> NIK