Seems to be working brilliantly!
Thanks Harlan
Thanks JE
Thanks Jason


"Harlan Grove" wrote:

vnsrod2000 wrote...
Sorry, I see now that it is applicable...However, maybe because I'm
not as
savvy with the formulas, I cannot get it to work. The one you include
doesn't
calculate properly(if it was intended to). If actual GP is $850,000,
then the
result should be $22,000.

Any further assistance is appreicated....Thanks.
....

JE may have been a little hasty in his specific formula, but the
technique is sound. Try

=SUMPRODUCT(--(GP{250,500,750}*1000),GP-{250,500,750}*1000,{0.03,0.01,0.005})