% Mark-up for retail store use

R

Retailnewby

I'm creating a worksheet to input the cost of my items I sell, input the %
mark-up, and have it tell me the retail amount. I have a calculator that
does it for me, but it doesn't give me the formula to input into excel.
Wikipedia said the mark-up formula as a percent is... Cost x (markup + 1) =
Sale Price. I'm not sure how to do this. Right now, I have an entire column
for the cost, and would like it to put the retail in the same row, next
column, like E1 would be the cost, and F1 would be retail price for that
item. Is this possible? Don't know where to start!
Thanks for anyone whom has the time to explain...
 
S

Sheeloo

If you have your cost in Col E starting from row 2, enter the markup
percentage in Col F starting at F2 (you can enter 0.10 for 10% or select Col
F, click on % sign and then enter 10)

then enter this in Col G in row 2 (G2)
=E2*(1+F2) to get the retail price

So if E2 has 100, F2 has 0.20 or 20% then you will get 120 in G2
 

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