discount

Hello so I need to create a lookup cell in excel. There are multiple tabs of information but I need to be able to type in a name on the front tab and for it to look up all tabs and return a discount value for that customer I searched? Make sense , I know the cells i need to include just need the...

Hi, I have a question regarding a categorization process in excel. Let me explain what I mean with that: The information is displayed below based on rows (important to know that the "IDs" are randomly distributed all the time). <tbody> Number ID1 Description ID2 Amount ID2 Description ID2...

I have a problem where I am trying to determine percentage averages for multiple customers in a given period. For example in the graphic below, "Cust 1" has 10 units at a 10 percent discount, Customer 2 had 20 units at a 5% discount and so on. For the quarter, the average discount is...

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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

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?

<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...

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) =...