Hi,
Please help.. Need a formula. I couldnt make the string?
i NEED FORMULA ON "H" that will output the following scenario? many thanks
<tbody>
</tbody>
<tbody>
</tbody>
Please help.. Need a formula. I couldnt make the string?
i NEED FORMULA ON "H" that will output the following scenario? many thanks
A | B | C | D (TOTAL b &c) | E | F | G | H | |
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NO DEMAND |
2 | 0 | 10 | 10 | 20 | 20 | 0 | 20 | In Process |
3 | 15 | 0 | 0 | 0 | 15 | 0 | 15 | Need to Order |
4 | 0 | 0 | 20 | 20 | 0 | 0 | 0 | Healthy Stock |
5 | 15 | 0 | 0 | 0 | 0 | 0 | -15 | Pulled beyond |
<tbody>
</tbody>
<tbody>
</tbody>