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

Special Formula
 

The following is an array formula. You must enter it with CTRL+SHIFT+ENTER
C2:IQ2 is your components
C6:IQ6 is product 3

=(SUM(NOT($C$2:$IQ$2="x")*(C6:IQ6="x"))=0)


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Moreaudjd" wrote in message
...
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

Special Formula
 

Not sure what the criteria are, but you could maybe use COUNTA to check it

For instance add a formula at the right of each row

=IF(COUNTA(A1:IP1)=0,"Build","Don't build")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Moreaudjd" wrote in message
...
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