"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