Q:

Can I have a logical AND inside an array formula in excel?

I have a worksheet like the following
ID|AVAILABILITY|PRICE
1 |1           |10,00
1 |1           |15,00
1 |0           |12,00
2 |1           |10,00

And in the same worksheet I do the following in MIN PRICE to get Minimun Price of available only products
I Save it as array formula
ID|MIN PRICE
1 |=MIN(IF(AND(table1[AVAILABILITY]=1;table1[ID]=L2);table1[PRICE]))
2 |

But I get 0,
is there any work around on this?

A:

You won't need the AND in this case, just:
{=MIN(IF(A:A=1;IF(B:B=1;C:C)))}
See here for more information about this!

