How do you use a scaling price markup within a single cell?

I thought I would share a simple scaling price markup tool, in which I hunted several threads and couldn't find what I was looking for. None of this is rocket science, but I think those of you that need a tool to determine how much something should be sold for based on a sliding margin scale. I needed something that could handle very low cost items that have large margins, to items that are fairly expensive and require a much lower margin.

I'm not an Excel guru by any means, and would love to expand on what this does. I am looking for someone that knows more about Excel to take what I have done here and provide the following if possible:
Take the workbook (attached), along with it's calculations and give me a single cell (Purchase Price) that I could type in any price (up to $10,000). Then, whatever is typed in that field would need to utilize the margin percentage (Column C in the attached spreadsheet) and automatically calculate the Selling Price and Profit and report that. This way, I could simply type in a single cell, and the it would tell me selling price and profit automatically. This can then be used for sales departments to determine a minimum, or expected price and profit on any item without constantly going to a manager for approval.

Example:

Purchase Price	Selling Price	Profit
$1.00	$5.00	$4.00

Any assistance would be much appreciated!

try this one...

Price Markup Tool.xlsx

use your named range in the sample file above

Formula:

Please Login or Register  to view this content.

Also, your named range only extends to row 317, but your data actually goes to 1017, so you should edit the named range to take into account the entire list

Edit
go into name manager, and replace the refers to
=Markup!$B$7:$C$317
with
=Markup!$B$7:$C$1017

Hope this helps

You are very welcome,and you enjoy them as well 1