selling

  1. D

    Help Needed!!

    Hi All, Hoping there's an easy formula for this as I am having a blank moment. So the below is a simple example of what I am trying to pull through in to column E. I would like to look up multiple "Item Number" which are the same, sometimes theres 2/3/4 of the same items. I would then like...
  2. G

    Need some help a formula Please

    I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...
  3. G

    Need some help a formula Please

    I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...
  4. J

    Working out Minimum Amazon Selling Price

    Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...
  5. M

    Calculating Selling price from a complex formula

    Hi All, I need a Excel formula to calculate my selling price based on a predetermined profit. What is know is: 1) The final profit after all the cost ($20) 2) The item cost 3) The merchant fee which is 10% (0.10) 4) The payment processor fee which is 2.9% + $0.30 5) The shipping material cost...
  6. E

    Formula for calculating eBay selling price

    Hi folks, I'm not sure if this has been posted before or if there is a guide on how to do this on this forum, so apologies if there is. I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my...
  7. S

    Calculate the selling price of a product

    Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...
  8. H

    Marketplace Profit Calculator - Calculating Variable Costs

    I'm looking for help regarding calculating profit margins when selling on marketplaces Amazon I'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel calculate what my selling price should be to make the 20%? Fixed Expenses...
  9. S

    Line chart xcel 2013 high pos nos n low neg nos

    142.88 143.97 144.50 145.00 142.00 -1.06 -1.06 -0.97 -0.80 -0.70 how can i show the correlation between selling price and Raw material update line chart
  10. E

    How to place the Sale Income in the correct Monthly Cell

    I have a workbook that has two tabs. Tab 1 = Selling price and selling month (i.e. in A1 I have the month #, in A2 I have the selling price of a house) Tab 2 = Columns for month 1,2,3, etc all the way out to month 24. (i.e in A1, etc I have month #, and in A2, etc I want the selling price...
  11. Y

    Calculating Commission fees to create my selling price

    Hi, I know it's Monday and I keep hitting a wall to calculate my selling price. I am trying to come up with a selling price where I can factor in all my costs and still make a 10% profit. The problem is I pay a 15% hosting fee based on the selling price I list, I want to make sure I am...
  12. B

    How to delete contents of another cell if current cell has a specific value

    Hi, I made this sample file. I would like to do the following under Nov Sales Sheet. https://docs.google.com/spreadsheets/d/1OawXSruy50khcw_zQDQtd7vhPlslpmsQUR-gUoCgrU4/edit?usp=sharing If SALE(C5) = "Y"(a drop down Y and N list), I would like to delete the contents of "SELLING FOR.(E5)" and...
  13. T

    Percentage Markup with negative Cost

    Hi I have a P&L that calculates the selling prices as a positive and the product costs as a negative but want to determine the % markup. I have a positive selling value $280,000.00 in Q50 and a cost that is a negative value in Q50 -$200,000.00 so the markup should return as 40% markup but cannot...
  14. A

    Getting info from HTML page source code

    Hi, I would like to ask if there is any way to retrieve information such as "sold by" which seller, and how much is the selling price...
  15. S

    Determine an unknown selling price, based on two known values out of 4

    Formula math logic issue: I know these things: 1. vendor cost 2. desired net margin dollars 3. commission percentage what I don't know and need to determine by formula is: 1. a selling price 2. a value of the commission % (I know the desired percentage, but since I don't know the selling...
  16. B

    Assume it's easy but I can't figure out

    Can I have a value inserted into a sentence? "If you are selling under the name of<insert data="" from="" a2="">,(data from a2) please select one" Thank you in advance.</insert>
  17. M

    Calculate eBay BIN price

    Is possible count by formulas eBay Buy It Now price ? My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90 Where is PayPal 3.4% + 20p Ebay 40p listing Ebay 10% Fee Postage £0.9 I need formula where I set my cost...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top