Forum Discussion

RoyJr's avatar
RoyJr
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 finding all Open orders that also have a "BER" status in column R. 

 

Little rusty on the AND function.

 

Thank you,

 

Roy

 

 

Formulas and Functions

2 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor
    May 20, 2020
    Try this:
    =IF(H10886="","",IF(AND(ISNUMBER(SEARCH("Open",F10886)),R10886="BER"),H10886+ROW()/10^10,""))
    • RoyJr's avatar
      RoyJr
      Copper Contributor
      May 21, 2020

      Perfect.

       

      Thank you.