Special Formula
Hi,
I have a spreadsheet that looks like that:
Components A1 A2 A3 A4 .... A250
Inventory x x x ... x
Product 1 x x ...
Product 2 x x ...
Product 3 x x ...
Basically, Product 1 & 2 could be done because all necessary components are in
stock, but Product 3 could not be delivered because A3 component is missing.
I would like to have a formula that determines automatically if a given product
can be build based on the inventory.
I started with IF statements, but the formula is too long...
Thanks
|