Translating an IF formula from Lotus 1-2-3 to Excel
Sorry, Ron, I didn't see your question. The output for the first cell
(M69) should be ------(blank) if the difference of par level (J69)
minus (E69) actual inventory divided by 2 < 0. This output is correct.
Then N69 should return ------ also. What these columns represent are
2 orders for the week, half on each of 2 days.
Does this make any sense? Thanks for your help.
Cheri
|