I'm having difficulty limiting a value for the number of pieces to order.
The formula I'm using to calculate the third column is =+IF(C5=D5>0,C5,"0") The problem I'm having is seen in row 4. The number sold is 7 and the adjustment is -5. I'm not sure how to have the "if true" statement become another IF function. Ideally, I'd like the number to order for row 4 to show as 2 in this case, or 0 if the number sold is fewer that the adjust number.
Thanks for your help!
Matt
Number sold Adjust Number to order
1 -4 0
2 -28 0
0 -13 0
7 -5 7
2 19 2
4 12 4
0 14 0
1 12 1
1 8 1
1 8 1
Bookmarks