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})
|