I want to autopopulate column B with a price based on 70% margin.

[Kristinak89]

I want to autopopulate column B (expected revenue) with a price based on 70% margin. So if the cost is 97.90 and the margin is 70% the column B should autopopulateimage 1.JPG

[Pete_UK]

So, is the cost in column A, and is this the cost price to you? If so, you can put this formula in B2:

=ROUND(A2*1.7,2)

then copy down.

Hope this helps.

Pete

[Kristinak89]

Hi Pete
This has not worked - can you see the image attached? does this help to visualise?
Thanks, Kristina

[Pete_UK]

You have added a picture after I read your first post, and I can see that your cost price is in column C, and it looks like it starts in cell C5. If that is the case, then put this formula in B5:

=ROUND(C5*1.7,2)

and copy down.

I'm not sure how you get the percentages shown in column F on your picture, because if you buy something for just under $100 and sell it for $350, that is a mark-up of over 350% (i.e. D5/C5).

Hope this helps.

Pete