Cell Reference:

A1, is my wholesale cost

B1, is my markup percent

C1, selling price (this cell should auto populate)

D1, gross margin in dollars (this cell should auto populate)

E1, gross margin in percent

Basically, I want my Selling Price (in cell C1) and my Gross Margin in Dollars (in cell D1) to dynamically change.

What I want to do is to be able to enter in my cost and enter in assumptions for either my Markup Percent or my Gross Margin Percent. If I enter in an assumption for Gross Margin Percent then I would like to automatically see what my Markup Percent would be and visa versa. By entering in these two pieces of information (my cost and either my Markup Percent or my Gross Margin Percent) I would like to see what my selling price should be and what my gross margin would be in dollars.

I found exactly what I am trying to do on the following web site but it does not show me the formulas so that I can do this on my excel spreadsheet. The web site is: (note, you will need Java to view this)

http://www.dinkytown.net/java/ProfitMargin.html

If there is anyone out there that would be willing to help me, it would be so much appreciated and I thank you in advance!

Andy