discount

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

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

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

Hi all, i would like to create a VBA so that to adjust the below data in right columns and entering headings too as my below extract. In sch.1. are the data which the columns are mixed and in sch.2. is the expected result. I would be greatly appreciated any help. Thanks in advance Sch.1...

good morning my boss has given me the task of fining the price before the discount was applied... so A1 has the discount price, b1 has the discount applied & c1 the full cost . does any one have the formula for cell c1? thank you for your help KR Trevor3007

Sorry to ask such a simple formula, but for some reason i have a brain freeze on this one I have a gross price and wish to apply up to three successive discounts showing the Total discount overall <colgroup><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>...

I am trying to create one cell that shows the discount approval level required which varies by quantity. Thank you for your patience. So here is the matrix of what discount can be given at what quantity. The only require is to output a cell showing discount, which will then be conditionally...

Hello Guys ! Is there any formula to do automate this calculation ? <tbody> A B C D 1 10% Discount 3 ( Insert Formula ) 30 2 20% Discount 10 30 3 15% Discount 50 333 4 VIP 7% 10 143 5 Weekend 25% 25 100 6 Weekend 25% 25 100 7 Weekend 25% 25 100 8 15% Discount 10 67...

Hi all, I have the following table to Discount the annual rate to get the present value. I am wondering if there is any formula that i could implement to get the monthly Discount factor so that i can figure out the difference. <tbody> Annual rate 8,00% Discount factor PV...

I have a sheet which calculates charges due on an account. I have a box at B10 which can be completed to offer a discount. I have a dropdown which references to box D5 where a user can select a 'Loyalty Discount' (shows "1" for no discount, then either "2"or "3" for the level of discount...

Hi, I'm kind of lost - I am able to do an IF and VLOOKUP to get the required data but now i am trying to add another IF and VLOOKUP formula to multiply by the discount rate if the purchase if made before the discount end date. I'm really struggling to grasp on the best action to achieve these...

Hi, Struggling to get my head around how to create this formula. I need a formula that will only apply a 10% discount if the item was purchased before a specific date. Any ideas? Thanks,

Hi all I need the discount percentage displayed in discount percentage column, based on total cost and total delivery https://photos.app.goo.gl/twbWqPeGBPVhtLot1

Hi there; I have a small problem, I need to condense this table of formulas into one calculation and this is beyond my meagre skills, I build the table to calculate some discount bands, basically applying a rate to the cell highlighted (red) taking the figure apart portioning it into bands and...

Could someone please help me with a basic algebra formula that I can calculate it in Excel? I need to calculate [variable x] - 35% = known integer (for example, $44.85) So, I know the cost of my product. Let's call it $19.95 I know the discount I want to offer: 35% I need to be able to...

Hi All I'm new to the site. Hopefully I have posted this properly! In the file I'm working in, there are a series of cell into which the user can enter a value of their choice. These cells are all independent of each other so the value are also separate and independent of each other. I...

Hi guys, I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction.... I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the...

Happy New Year to everyone! I have a question that is centered around a policy-change, whereby, a worksheet that had a discount that used to apply to all items in a column (general discount, and therefore, quite easy to write) that now excludes items that are "services based". I have all...

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

I have a workbook with multiple sheets, but am only concerned with the first two; Product Inputs and Outputs. Product Inputs includes information such as item identification numbers, dimensions, weights, etc. Outputs then takes those numbers and calculates profit, overhead, and quantity we...