Forum Discussion

Copper Contributor

May 20, 2020

Solved

Search Parameter Expansion

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 findin...

Formulas and Functions

RoyJr
May 21, 2020
Perfect.

Thank you.

JMB17

Bronze Contributor

May 20, 2020

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

RoyJr

Copper Contributor

May 21, 2020

Perfect.

Thank you.