Search Parameter Expansion

[RoyJr]

Hello,

I have this formula =IF(H10886="","",IF(ISNUMBER(SEARCH("Open",F10886)),H10886+ROW()/10^10,"")) 

It works perfectly for finding Open orders. Now I want to add to the formula for finding all Open orders that also have a "BER" status in column R. 

Little rusty on the AND function.

Thank you,

Roy

[#2]

Try this:
=IF(H10886="","",IF(AND(ISNUMBER(SEARCH("Open",F10886)),R10886="BER"),H10886+ROW()/10^10,""))

[#3 · Accepted solution]

Perfect.

Thank you.