|Is this what your data looks like:|
B C D G H I J
1) Stock before Stock now Amount sold Level 1 Level 2 Level 3 Level 4
2) $40.00 10 20 30 40
3) 7.50% 9.50% 10.50% 11.50%
So where are you having problems?
Is it with this:
I can do level 1 and 4. Not sure how to calculate levels 2 or 3 so that the answer is provided only if it is within the range otherwise leave blank.
If it is, then we need more information.
What are the constrains you mean when you say within the range
Also you say:
In order to reduce the amount of variables in this equation
Please DON"T one of those variables may impact the answer.....
The more information you supply
the more complete answer we can work out.