Forum Discussion
Excel formulas/function help
Hi, I am trying to do an analysis to determine what is the best order qty and pricing considering inventory carrying cost. I put together an example but my file has more than 200 lines. This tab...
Check this ,, has formula in cell D3:
=IF(AND(B3=$F$2,C3>=$F$3),"Yes","No")
An array (CSE) formula in cell H3:
{=IFERROR(INDEX(A$3:A$13, SMALL(IF($D$3:$D$13="Yes", ROW($D$3:$D$13)-ROW($D$3)+1), ROW(1:1))),"" )}
- Finish formula with Ctrl+Shift+Enter, and fill across the range.
- Adjust cell references in the formula as needed,
Rajesh_Sinha thank you very much.
does this mean to calculate values in D (best order qty), I need to adjust F2 and F3, as each PN have different pricing tiers?
That is something I hope to shy away as my actual file has maybe 100-200 unique PNs and each PN has 3-6 price tiers.
