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.


[TABLE="width: 528"]
<colgroup><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][TABLE="width: 528"]
<colgroup><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 531"]
<tbody>[TR]
[TD]Customer Requested
[/TD]
[TD]11/19/2018
[/TD]
[TD]11/20/2018
[/TD]
[TD]11/21/2018
[/TD]
[TD]11/22/2018
[/TD]
[TD]11/23/2018
[/TD]
[/TR]
[TR]
[TD]Texas
[/TD]
[TD]300
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Kentucky
[/TD]
[TD]
[/TD]
[TD]200
[/TD]
[TD]400
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]California
[/TD]
[TD]200
[/TD]
[TD]200
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 531"]
<tbody>[TR]
[TD]Running Inventory
[/TD]
[TD]11/19/2018
[/TD]
[TD]11/20/2018
[/TD]
[TD]11/21/2018
[/TD]
[TD]11/22/2018
[/TD]
[TD]11/23/2018
[/TD]
[/TR]
[TR]
[TD]Inventory-Texas
[/TD]
[TD]-200
[/TD]
[TD]300
[/TD]
[TD]1400
[/TD]
[TD]1600
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Inventory-Kentucky
[/TD]
[TD]
[/TD]
[TD]500
[/TD]
[TD]700
[/TD]
[TD]200
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]Inventory-California
[/TD]
[TD]300
[/TD]
[TD]50
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.


[TABLE="width: 528"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][TABLE="width: 528"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 531"]
<tbody>[TR]
[TD]Customer Requested[/TD]
[TD]11/19/2018[/TD]
[TD]11/20/2018[/TD]
[TD]11/21/2018[/TD]
[TD]11/22/2018[/TD]
[TD]11/23/2018[/TD]
[/TR]
[TR]
[TD]Texas[/TD]
[TD]300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kentucky[/TD]
[TD][/TD]
[TD]200[/TD]
[TD]400[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]California[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 531"]
<tbody>[TR]
[TD]Running Inventory[/TD]
[TD]11/19/2018[/TD]
[TD]11/20/2018[/TD]
[TD]11/21/2018[/TD]
[TD]11/22/2018[/TD]
[TD]11/23/2018[/TD]
[/TR]
[TR]
[TD]Inventory-Texas[/TD]
[TD]-200[/TD]
[TD]300[/TD]
[TD]1400[/TD]
[TD]1600[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Inventory-Kentucky[/TD]
[TD][/TD]
[TD]500[/TD]
[TD]700[/TD]
[TD]200[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Inventory-California[/TD]
[TD]300[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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