Exclude certain cells from min calculation if criteria not met

Hello all,

I am working a project to compare the lowest price of three companies on multiple products.

I want to add a column to show if the item is in stock. I have applied a formula to show if there is a sufficient number of items in stock producing either "Y" or "N". I need excel to check this column before telling me the lowest priced item. I have therefore worked out this formula for if all items are in stock

Formula:

=IF(ISBLANK(B5),"",IF(AND(E5="",G5="",I5=""),"",IF(AND(G5="Y",K5="Y",O5="Y"),(MIN(E5,I5,M5)),FALSE)))

.

( Please note the following part of the formula is to prevent errors

Formula:

=IF(ISBLANK(B5),"",IF(AND(E5="",G5="",I5=""),"",

)

My issue is that they are 11 possible outcomes in how the items could be in stock, I.E. all in stock, all out of stock, one in stock and the other two out of stock in various combinations.

Whilst the "false" part of the above formula could be substituted for each different possible solution, is there a simplified way of doing this?

I have attached a copy of my workbook for your ease.

Many thanks,

PER11