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

1. ## 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!

2. ## Re: How do you use a scaling price markup within a single cell?

try this one...

Price Markup Tool.xlsx

3. ## Re: How do you use a scaling price markup within a single cell?

vlady, thank you very much for the response. Conceptually, you have exactly what I am looking for. Unfortunately, and I am not sure why, but the calculations match on smaller amounts, but the larger I go on purchase price, it doesn't match the correct selling price. Starting with \$100, it is off by 1\$, and then exponentially is off the larger the purchase price. I like how it adjusts the selling price in between the buy range. We are really close.

4. ## Re: How do you use a scaling price markup within a single cell?

use your named range in the sample file above
Formula:
`Please Login or Register  to view this content.`

5. ## Re: How do you use a scaling price markup within a single cell?

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

6. ## Re: How do you use a scaling price markup within a single cell?

dredwolf and vlady, thank you so much, it works perfectly now!! Enjoy the upcoming holidays!

7. ## Re: How do you use a scaling price markup within a single cell?

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1