35% profit set

N

nicholas hall

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
 
F

Franksta

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top