Excel: It All Adds Up Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Home -> Number ->Percentage

Calculate the Retail Price

The numbers we entered into the B column represent the wholesale cost. That is what Charlotte’s Web Site paid to purchase the items that go into a fruit basket. In order to make a profit, we need to figure out how much we need to markup the cost to get our retail price.

4. Format the Percentage

The Retail Price equals the wholesale cost multiplied by the percentage.

 

To start, select all of Column C, Markup.

Go to the Home Ribbon. Look for the Number Group and click on the Percentage (%) formatting.

5. Enter the Percentage

A standard keystone markup is 150%. Type 150 in cells C2 through C5. Excel will automatically add the % sign.

So far so good.