discount

  1. T

    if value = certain text then return value of different cell

    Hi everyone ! so i need some help with what i said in the title. i will try the best i can to explain what i need. i have three collums product code, type , discount code the 3rd collum will have a specified discount code which can be anything, for now i only have this one "FACELESSCAT10"...
  2. I

    Excel Validation rule to prevent cell from going below a certain percentage based on value of another cell.

    Hello! I'm trying to create a quote template in Excel. The issue happens when sales wants to give a discount, but then give too big of a discount on the price. To solve this issue we've duplicated the price in another hidden cell and reference that cell in the validation rule. The idea is...
  3. B

    How to Calculate my discount in PowerPivot?

    Hi all, I have a problem with calculating discount in PowerPivot analysis. I have dCalendar , dDiscount, fSa*****ok . dDiscount columns: DiscKey, StartDate, EndDate, Product, DiscountName, DiscountPercent fSalebook columns: OrderDate, Product, Qty, Sales, Discount dCalendar columns...
  4. R

    Nested "IF" issues!

    I need to be able to say in a cell "If the amount in B4 is over 800 dollars the customer gets 10% discount so cell B5 will show 10% or if the amount is over 1000 they get a 15% discount, or if its over 2000 dollars they get a 20% discount" I swear every time I try to get this to work I get an...
  5. J

    Find percentage and change it

    I have several customers. Everyone has her own discount %. When I write a name, I want to find their discount %,calculate the price, round the price up, then to change the discount number. For example if Jane has 10%, the price is 960,after discount it will be 864, but as i will take only with...
  6. K

    Showing price discount, but hiding price increase...need help with current code.

    I've been building a workbook to do Quotes/Purchase Orders/Order Confirmations..etc. I have a macro which gives a pop up window to enter a price percentage discount/increase. It works fine and shows the amount discounted/increased into the active cell. However, even though clients love seeing...
  7. P

    What is the price when i have margin, cost and discount

    Hi, Hope somebody can help with the below formula, the 1st, 3rd and 4th columns we fill in. I have set up formula's to work out the next 3. I'm try to work out the list price, starting at the cost but incorparating the discount and making a 22% margin. The first table works final until you...
  8. E

    Discounts on excel

    Hi there, i was just wondering how and if you can create an offer on excel. For example i work in a sports shop and i have created this spreadsheet and on it am i selling footballs for £7.50. I have created formula's where once you type the quantity next, it totals the price up and inserts it...
  9. B

    How to create a formula for weighing and summing an undefined number of rows?

    Hello, I am looking for help to crack this one: I want to calculate the total discount to customers based on discounts on individual products. However the number of products vary from each customer. How can I do this fast and automatic in excel? (And I am stuck with a column in between the two...
  10. S

    give a 5% discount help needed please

    I have a excel 2007 spreadsheet that works out a total of a customers order, how do I get it to give them a 5% discount. so if their total in B29 = £423 I would like b30 to give me the amount with the 5% discount deducted. Hope this make sense thanks in advance
  11. D

    Formula for Deliveries!

    I want to work out a formula that can read a quantity from one cell and work out delievery costs for the items dependant upon the number in that cell providing a dicount for certain numbers: 1 item = 80 2-5 = 50 5-10 = 30 10+ = manual price required. help?
  12. 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...
  13. F

    Discount Function Required

    Hi There, My first post to this forum. thank you everyone who answers these questions. I need an Excel formula that computes a discount such that: f(1) = 10 f(2) = 20 f(3) = 30 f(4) = 40 f(5) = 40 f(6) = 50 f(7) = 60 f(8) = 70 f(9) = 80 f(10) = 80 f(11) = 90 f(12) = 100 f(13) =...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top