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 McGimpsey" wrote:
Did you try it?
The whole article is based on entering your AGP in one cell...
Your example is a rather straightforward application of the first
technique shown:
=IF(D29=250000,SUMPRODUCT(--(D29{0,500000,750000}),
(D29-{0,500000,750000}),{0.03,0.01,0.005}),0)
The remaining techniques make things more flexible, but aren't required.
In article ,
"vnsrod2000" wrote:
Thanks, but I don't think the SUMPRODUCT function will work because I'm not
going to have the data listed...
In my spreadsheet, a person will type in the Actual Gross Profit in cell D29
and then the result of the calculation (where the formula is) will be in cell
D31.
|