Formula Help

[Dastnai]

Hi Everyone,

I am looking for a way to build a formula to look at Customer Requests by date compared to inventory. My customer requested are already added into my ending inventory on my report*. So if there is a customer request I need a formula to check if our inventory was positive during that time. Here is an example of my table.

<colgroup><col><col><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>

Customer Requested	11/19/2018	11/20/2018	11/21/2018	11/22/2018	11/23/2018
Texas	300
Kentucky		200	400
California	200	200

<tbody>
</tbody>

Running Inventory	11/19/2018	11/20/2018	11/21/2018	11/22/2018	11/23/2018
Inventory-Texas	-200	300	1400	1600
Inventory-Kentucky		500	700	200	100
Inventory-California	300	50

<tbody>
</tbody>

 

[Dastnai]

Hi Everyone,

I am looking for a way to build a formula to look at Customer Requests by date compared to inventory. My customer requested are already added into my ending inventory on my report*. So if there is a customer request I need a formula to check if our inventory was positive during that time. Here is an example of my table.

<tbody> </tbody>

<tbody>
</tbody>

Customer Requested	11/19/2018	11/20/2018	11/21/2018	11/22/2018	11/23/2018
Texas	300
Kentucky		200	400
California	200	200

<tbody>
</tbody>

Running Inventory	11/19/2018	11/20/2018	11/21/2018	11/22/2018	11/23/2018
Inventory-Texas	-200	300	1400	1600
Inventory-Kentucky		500	700	200	100
Inventory-California	300	50

<tbody>
</tbody>

Please notate if my inventory is greater than 0 on all days there is a customer request than accept, if not decline.