Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating a special formula | New Users to Excel | |||
ANY SPECIAL ARRAY OR OTHER FORMULA | Excel Discussion (Misc queries) | |||
Special Lookup Formula | Excel Discussion (Misc queries) | |||
Paste Special Formula | Excel Worksheet Functions | |||
special sum formula | Excel Worksheet Functions |