On Tue, 12 Aug 2008 01:39:59 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:


"Ron Rosenfeld" wrote in message
.. .
On Mon, 11 Aug 2008 16:50:01 -0700, Siper1

wrote:

This formula that you gave me earlier works greatt until I exceed 500,000
units (ie. 480,000 units = $192,00)

=D19*MIN(--J3,C19)+D20*MIN(MAX(J3-C19,0),C20)+D21*MAX(J3-B21,0)

J3 = 540,000

I could use something as simple as this but I need it to cover multiple
periods and want to show the results on a single spreadsheet:

I did not give you that formula. You've been responding to me but *Rick*
gave you that formula.

And I posted a correction for the formula in the *new* thread the OP started
shortly after midnight (my local time) where he repeated the question you
just responded to.

Rick

Hopefully he'll be able to straighten things out and get something useful from
one of our attempts.
--ron