About Us

Abbeypost

Thanks for the reply which works great. I think that now I see the structure, I can change the figures or alter the quantity/price bands if needed.

Sanity restored THANKS.

Quote:

Originally Posted by Vacuum Sealed

On 1/02/2012 2:56 AM, wrote:
=(0.2*H5)-
(0.05*(MAX(H5-100,0)))-0.05*(MAX(H5-250,0))-0.02*(MAX(H5-500,0))

Just to expand on Allan's formula, I converted the actual decimals to a
cell reference to allow for price changes.

Keep in mind though this is only handy for an on-the-spot pricing and
should not be used in a Historical/Archival way as it will have a global
effect, changing all cells that rely on this.

=(H1*H5)-(H2*(MAX(H5-100,0)))-H2*(MAX(H5-250,0))-H3*(MAX(H5-500,0))

Change the cells addresses to suit your sheet layout/structure, you
could even house the pricing on another sheet and point to those cells.

=(PricingSheet!H1*H5)-(PricingSheet!H2*(MAX(H5-100,0)))-PricingSheet!H2*(MAX(H5-250,0))-PricingSheet!H3*(MAX(H5-500,0))

HTH
Mick.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Progressive chart	Marius	Charts and Charting in Excel	2	June 5th 09 05:37 AM
progressive sum	balu	Excel Discussion (Misc queries)	3	November 18th 07 06:12 PM
Progressive Calculation	nospaminlich	Excel Worksheet Functions	5	November 1st 05 09:03 AM
progressive select	Mike	Excel Worksheet Functions	1	June 8th 05 02:08 AM
Progressive summing	Maarten	Excel Worksheet Functions	5	April 27th 05 10:25 AM

Menu

About Us