# discount

1. ### Excel vlookup with variable information

Helloooo, Is there a way please to lookup information from other spreadsheets based on variable information? This is quite hard to explain so I’m just going to list out what I have below and hope that someone can make sense of what I am trying to ask! So this is a little mock up of my scenario...
2. ### IF with two conditions

Hi I need formula with if command in column E based on data from A to D, Secondary no Discount <tbody> Segment Transmission Value Discount % Result Primary AUTO 1000 20% 200 Primary<strike></strike> MANUAL 1000 10% 100 Secondary AUTO 1000 0% 0 Secondary<strike></strike> MANUAL...
3. ### Dax Measure of LAST DISCOUNT Amount

Hello all, I am in desperate need of some help with rolling back our inventory and seeing what the discount amount was on a prior date. I have a measure that rolls back the date and I have a table with the historical discounts by date. What I need to see is: SKU QTY DISCOUNT AMOUNT VALUE...
4. ### Making a letter point to a specific cell or equation?

HI all, I have just joined as i have spent the last hour unsuccessfully searching the net trying to sort out an excel question i have, what i'm trying to do seems pretty simple but i cant figure out how to do it... I'm a basic excel user, using it mainly to create pricelists. So here is the...
5. ### Pivot Calculation

I would like to add an additional row in my pivot table for percent of Gross Sales below each of the following categories. Any idea if this can achieved? Gross Sales POD Expense Commissions Rebate Discount Freight Costs Net Sales \$4,69,655 \$293,212...
6. ### Returning specfic value based on customer X spend which is an array

I have a question on returning X customer's discount percentage Y, based on their Z spend amount.Ie: I have a list of 5000 customers, Various min and max spend and its corresponding discount. For customer John, i can locate John by index match among the list of customers. Then when at customer...
7. ### A question about IF AND?

Hi, I have a work book with two sheets. On the Sheet1 I have a table with data for Restaurant in cells A1 to I4 Then I have data for Super market in cells A6 to I9 Finally I have data for Coffee shop in cells A11 to I14 <tbody> A B C D E F G H I 1 Restaurant Discount offer...
8. ### Formula for total price less bulk discount

Hi: I have been struggling for a solution and I need some help. Expected values are in column H to J In H2, I am looking for a formula for total cash due: = look up value in A2, return ticket price x tickets sold, less cash discount (per discount band) x ticket sold <b>Excel...
9. ### 1 formula for 2 discount % and 3 countries

<tbody> Area Price Discount 1 Discount2 Net price A 100 20.5 3.78 79.5 B 100 15.7 2.95 84.3 C 100 11.3 1.87 88.7 A 20.5% 4.75% B 15.7% 3.5% C 11.3% 2.105% </tbody> Please help to make single formula in Net price column for example in E2...
10. ### Joining Multiple Tables Together and zero out values

I've been googling for a while and can not find the solution to this. I'm trying to Join a Sales Table with two separate discount tables. When I join the tables together the Sales is repeated on each line. I want to have the sales number show up only once and have the rest of the rows show...
11. ### NPV Discount Rate

I have been offered 2 payment methods as I was buying some tools for a company I work for. I need your help to assess the best method. Here it goes, Total cost is \$100 and I don't want to pay it all in advance. First offer is they increase the total cost by 30% (they call it "financing cost" ...
12. ### VBA: In a Column Fill empty Cells with Entry from Pop Up Window

Hello, I need assistance with a little bit of VBA code. The code needs to: Identify all the blank cells in Column D, It is the last column. Display a pop up dialog / Userform A response is entered by the user in the dialog. Whatever is entered into that dialog will then fill ALL of the blank...
13. ### Taking the right amount out of more than one condition

Hi friends, I took picture of my problem as it is easier for me to explain on it, as I cant fully solve this problem. So I have to determine percentage of discounts (F row) according to conditions in table on right side. 1) For different suppliers I have different discount rates on different...
14. ### Really messed up Excel exports from financial software

Hello, We use accounting software from a big, reputable vendor. They offer Excel exports, but really don't know how to make them proper. What it looks like is shown below. The problem is the multiple-row layout. How would I go about to fix this to a normal structure of 1 entry per row? It's...
15. ### USERELATIONSHIP filter question

I've got a measure where I'd like to have a USERELATIONSHIP clause in the CALCULATE. The code below works... however, I'm not clear why I can't add the USERELATIONSHIP as a filter parameter to the "inner" CALCULATE. If I do that without the outer CALCULATE the measure returns blank<blank>...
16. ### Multiple IFS with Calculations

I am having issues writing a formula that will change the discount of a quote based on a subtotal. The Formula...
17. ### if statement - testing a single cell works, testing a range of cells not working

The below works: =IF(OR(I10>H10,I11>H11,I12>H12,I13>H13,I14>H14)," Discount Given is greater then Max. Discount", IF(OR(C3={"B","W"}),"Discount can be UP to 7.5 %", IF(OR(C3={"L","N"}),"Disc. Max. 3%/Midwest only - up to 7.5 %", IF(OR(C3={"D","V","X","SR"}),"ENTER xx for MAX...
18. ### How to return a discount amount based on multiple ranges in Excel

I've got a table with the following columns Quantity, Price, Sub Total, Discount Tier, Discount Amount, Total If the quantity is between 100 and 200 I want to show a 5% discount in the Discount Tier column If the quantity is between 201 and 300 I want to show a 7% discount in the Discount...
19. ### Creating new rows via a cross reference

OK guys, be patient with me as I try my best to explain what I need in a way that doesn’t make me look like a raving lunatic. (I might be one, I just don’t want to look like one). OK I am open to any solution that works in Excel or Access (including SQL statements) because I really don’t know...
20. ### Tiered Pricing SumIF Help

Hi - I am trying to calculate the overall price based on a tiers of discounts: <colgroup><col><col><col span="2"><col></colgroup><tbody> Lower Band Upper Band List Price Discount% Discounted Price 0 7,500 £10.00 0% £10.00 7,501 15,000 £10.00 3% £9.70 15,001 25,000 £10.00 6% £9.40...