answersLogoWhite

0

Cells are identified by both row and column headings. If E is a whole column of Asking prices and F is a whole column of corresponding selling prices, then you would go to the first ROW (i'll assume it's row 2) and enter the formula in G2:

= E2/F2

Press enter, then copy and paste this or use the fill down option to fill it into the rest of the cells. Excel is smart enough to adjust the formula for you (e.g. so the one in row 3 would be =E3/F3)

Select all the cells you want to be displayed as percent and click on the "%" button on the toolbar to make them into percents.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you calculate Direct Margin as a percentage?

(selling price - direct cost)/selling price = direct margin


How do you calculate cost from markup on selling price?

To calculate cost from markup on selling price, you first need to understand the relationship between cost, markup, and selling price. The formula for selling price (SP) with markup is SP = Cost + Markup. If you know the markup percentage, you can express it as a fraction of the selling price: Markup = SP × Markup Percentage. Rearranging the formula gives you Cost = SP - (SP × Markup Percentage), allowing you to calculate the cost based on the selling price and the markup percentage.


How do you calculate Selling Price if you know Cost price and Profit percentage?

profit can be calculated from profit percentage and cost price.profit percentage=profit*100/cost price.profit=selling price-cost price


How do you calculate selling price if you know cost and gross profit percentage?

Selling price = Cost of goods sold + Gross profit percentage on sales


How do you calculate the selling price if you know the cost price and margin percentage?

Convert the margin percentage increase (decrease) to the absolute increase (decrease). Add (subtract) to (from) the selling price.


How do you calculate the selling price if you know the cost and gross profit percentage?

Cost = Selling Price - Gross Profit By using this formula or method easily we can get the selling price of the product


How do you calculate Average selling price?

how to calculate average selling price


How do you calculate cost price when given sell price and profit percentage?

Cost Price = Selling Price - Profit Profit = Selling price * profit percentage Example: Selling Price = 10 Profit % = 50% Profit = 10*50/100 = 5 Cost price = 10 - 5 Cost Price = 5


How do you calculate cost price when given sell price and loss percentage?

Cost Price=(100/(100-loss percent))* Selling Price


What is a correct formula when markup is based on selling price?

When markup is based on selling price, the formula to calculate the cost price is: Cost Price = Selling Price × (1 - Markup Percentage). Here, the markup percentage is expressed as a decimal. For example, if the selling price is $100 and the markup is 20%, the cost price would be $100 × (1 - 0.20) = $80.


How do you calculate percentage if selling price and cost price are given?

P/L% = P/L * 100 divide by C.P


How do you calculate the difference between margin and markup in pricing strategies?

To calculate the difference between margin and markup in pricing strategies, you can use the following formulas: Margin (Selling Price - Cost) / Selling Price Markup (Selling Price - Cost) / Cost Margin represents the percentage of the selling price that is profit, while markup represents the percentage of the cost that is profit. The key difference is that margin is calculated based on the selling price, while markup is calculated based on the cost.