markup

  1. B

    IF statement for price markup

    Someone please solve this equation. I have a markup equation that I fill down. I'm trying to net no less that 5.00 but I have products with a wide range of total cost. Price = Total cost + Markup percentage. Net = Price - Total cost. That part works great. The following is what i'm trying...
  2. D

    Markup/Markdown a total based on a %

    I apologize in advance if this has been answered. I searched and couldn't find my exact issue. I am creating a quote tool that lists items with a column for cost, sell, and profit. Those columns are totaled. Then I have an area for lease info where the total in the "sell" column is...
  3. B

    SUMPRODUCT( ,SUMIF()) - add 1 to each element in SUMIF array

    Hey all. I have a worksheet which has a bunch of products. These products are keyed by a product type. Beneath this product list, there is a subtotal, profit (markup * subtotal), tax, commission, and a final total. Markup rate, tax rate, commission, etc. can vary based on product type (e.g...
  4. B

    Array INDEX-MATCH with dynamic criteria and SUMPRODUCT?

    Hey all, I'm looking for a way to dynamically lookup markup rates from another worksheet, multiply them by the correct prices for matching products on the sales worksheet, and display it as a total markup amount beneath the subtotal. Some of the items, however, need to be excluded from the...
  5. B

    Reverse calculate margin

    First time poster and desperate for help! I work in sales spend a lot of my time working out selling prices for my team and me. As a sanity check, I use a spreadsheet (I call my Margin Calculator) to enter all costs and then, depending on the client, the final selling price rather than pen and...
  6. H

    Variable Pricing Formula

    Hello. I have a quote sheet that marks up my price by a certain percent. The way I have it set up now is for a 10% markup and I adjust it manually. C1 = .10, C2 is where I enter the cost, B2 = C1*C2, A2 = B2+C2. I would like change this to vary the markup percent based on the cost. Ie. as the...
  7. A

    Markup

    Hi as an employee of an Amazon business, I want to make a listing on amazon. How can I calculate a markup of 10% in excel? - the markup is “on the cost of the item plus the fee amazon takes after the item being sold” which is a percentage of the listing/sale price? Is it possible to have an...
  8. T

    Quick Append in Power Query???

    I have a table that has the following Format <tbody> Plate Group Count Market Cost/LB Markup Markup % <= 1.5 and <= 120 319 .46 .39 .07 18% </tbody> I am trying to see if there is a simple way to convert that to <tbody> Plate Group Type Value <= 1.5 and <= 120 Count 319 <= 1.5 and <=...
  9. GlenCoco

    Exponential decreasing percentage with a floor

    I've learned that (almost) anything is possible in Excel, so I'm confident someone knows the solution to this :) I'm working on a margin markup formula for our customer reps to use, but the markup percent needs to exponentially decrease as the hard pre-quote value rises, until reaching a set...
  10. C

    Returning variable value

    Hello, I have the below text that I would like to extract the person's name (highlighted in bold) who is responsible for "Markup Changes" .. essentially this is the second instance of "responsibility of" Cell text looks like this variable text (Responsibility of: surname, firstname, due...
  11. I

    Report Filter in OLAP cubes in Excel

    Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...
  12. I

    Report Filter in OLAP cubes in Excel

    Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...
  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. J

    Creating value ranges to calculate cost markup.

    I have a sheet of 30,000 parts with my vendor costs and I'd like to figure out a formula to apply a certain markup percentage for a certain range of values. $.01-$.49 : Markup Percent 809% ( or mark-up multiplier= 9.091) ex. $.30*9.091=$2.73 $.50-$1.99 : 567% (6.667) $2-$24 : 212.50% (3.12)...
  15. L

    Help with formula please

    So this is what I am dealing with. When I start, only column N is filled in. I have to calculate 2 different markup prices in the columns to the left. My problem is, the file is many pages long and column N sometimes has blank fields or text, as you can see, so I am unable to just copy a formula...
  16. R

    Declining/Variable/Curved Mark-up

    Hi Mr.Excel, I'm trying to streamline my business and I'm having a heck of a time with a spreadsheet I'm working on. I'd like to create a spread sheet for my estimators that allows them to put in the quantity, description and cost of goods and my spreadsheet will determine the mark-up based...
  17. C

    Longtime fan from the TechTV days. Have a question on applying formula to highlighted cells

    Good afternoon. In my job, I receive cost invoices that I must convert over to sell invoices. Since markup is typically static across multiple lines of the invoice, is there a way for me to apply markup percentage to the cells that I highlight and replace those results right back into the cells...
  18. L

    Percent markup and discount in a range

    <P style="MARGIN: 0in 0in 10pt" class=MsoNormal><FONT size=3 face=Calibri>Background: (1) I have a (Windows Vista) 2007 Excel worksheet with 14 columns and 2,354 rows, for a total of 32,956 cells. The file’s size is 304KB. Alone, the file serves as our parts and price list for our wholesale...

Some videos you may like

This Week's Hot Topics

Top