discounts

Hi there. i have been trying to work out if its possible to create an excel formula to work out a 4 for 3 calculation. e.g. product 1 = £34.99 Product 2 = £25.99 Product 3 = £30.99 Product 4 = £29.99 It will add up the 4 items but remove the cheapest item in this case product 2 and return...

I have a PowerPivot table similar to the following (obviously thousands more lines): <tbody> P&L Category Amount Something else I may Pivot on Sales 100 A Sales 100 A Discounts 20 A Discounts 30 A Returns 10 C Sales 200 C </tbody> I want to get a summary of Net Sales in a Pivot...

So. I am not a heavy exel user, but recently have taken on a role that could really benefit from a 'dynamic' checklist. Here is the Scenario. I check incoming contract renewals, and depending on the company that the contract is with, each has a differnent set of discounts that needs to be...

Hi Folks, I am wondering if there a pre-existing excel formula to subtract multiple percentages for a certain value. For example, imagine you are offering a product which has several discounts depending on the quantity purchased. So, if you buy 100 of them, you will have an additional...

Hi I have a worksheet with 60 Columns. Col A contains product groups. Working across the sheet all subsequent cols on row1 have customer name and then running down the col various discounts that customer receives for the different product groups. The cols contain some blanks as not all...

I want to calculate a discount for a sale using either a % off or a $ off. For example, I set up a drop down box of available discount codes that correspond to a list of discount percentages or flat dollar value. Of course, when Excel calculates the discount, it doesn't know if I mean a % off...

Hello there, So I need to formulate a matrix out of two tables: I have the inventory table has the product number and the current full cuantity available: <tbody> Product Inventory A 400 B 60 </tbody> I also have a matrix and it's arranged in orders of each product per customer...

Hi, I have read how to ignore #N/A using sumif in another post but I don't think this will work in my case. I am trying to ignore all rows containing #N/A, not only the part of the formula containing the #N/A cell. I have a file I can upload with new data all the time so just filtering away...