View Single Post
  #5   Report Post  
fsufan13
 
Posts: n/a
Default 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