Calculate the Retail Price

The numbers you 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, you have to figure the retail price.

 

The retail price equals the wholesale cost multiplied by the percentage.

5. Try This: Format 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.

Try This, Too: Enter the Data

A standard keystone markup is 150%.

Type 150 in cells C2 through C5. Excel will automatically add the % sign.

So far so good...