progressive

Hi, I have a range of numbers at A2:A10. Column B shows the progressive sum (e.g. B2=A2, B3=B2+A3, B4=B3+A4 etc). Column C will either be blank or have a certain text "ABC". I would like the progressive sum result at column D instead of B with some criteria. I need a formula at D2 which I can...

Hope you can help!! I have a progressive pricing formula I need help with, been tearing my hair out Each band gets individual earnings in steps apart from <10 that gets nothing. In the below example customer sells 35 baskets, so will reach the 4th band. Band 1 - Zero Band 2 - 10 * £1.15 =...

Hi all, Hoping you can please help, I have reviewed many of the proposed solutions to a progressive calculation I am trying to solve but am not winning (or looking hard enough). The solutions I have found as far deal mainly with percentages which is not working completely. I have a progressive...

Hello, I am struggling with a progressive pricing problem and hoping you can help. I have a unit quantity range and a price I need to calculate. So for instance, in column B6:B10, I have the unit quantities. In column C6:C10, I have the price per unit. Unit Quantity (column B)...

Hello, I have been trying to solve a problem that involves using three different variables (Depth, Production level, and Year) to retrieve a number from a table. What I want is, given a certain production level (which can be any number), a depth (which will be one of the three options below)...

hi everyone, I have 2 columns difference in amounts and PAID AMOUNTS I want to progressively sum each cell in a column and when the total(s) exceed various amounts, I want to multiply by various % i.e. when difference is less than 50,000 x by .20 more than 50,000, multiply the difference...

I am trying to create a table for a customer based on an agreement we have where we will give a discount based on the purchase amount throughout the year. Here are my parameters Up to $10,000 0% discount Between $10,000 and $25,000 3.5% discount Between...