Help joining an if statement with a search statement

[Segurde]

Hello,



I need help joining the following scenarios:



If J4 in the "Offer Def File" page is blank, and L4 in the "Offer Def File" page reads "one-time", search for the number 1 in cell S5 of the active page. Return True or False.



Thank you in advance for your help.

[Olly]

Try:

Please Login or Register  to view this content.

[Segurde]

Hello Olly,

Thank you so much for your help. This worked.

[Segurde]

Hello,

I have an addition to the above formula. I am hoping you can help.

The final formula string looks like this:
=OR(AND(ISNUMBER(SEARCH("CE",Q5)),ISNUMBER(SEARCH("CENTSOFF",'Offer Def File'!R4))),
AND(ISNUMBER(SEARCH("PE",Q5)),ISNUMBER(SEARCH("PERCENTOFF",'Offer Def File'!R4))),
AND(ISNUMBER(SEARCH("NE",Q5)),ISNUMBER(SEARCH("PRICEPOINT",'Offer Def File'!R4))),
AND(ISNUMBER(SEARCH("NW",Q5)),ISNUMBER(SEARCH("NETWEIGHT",'Offer Def File'!R4))))

For IF Q5=PE, there are two options under R4. PE can equal to "Percent OFF" or "FREE".

How do I add "Free" to the "SEARCH" in R4 for the below scenario:
AND(ISNUMBER(SEARCH("NE",Q5)),ISNUMBER(SEARCH("PRICEPOINT",'Offer Def File'!R4))),

[Olly]

Add another OR statement, nested within the AND:

Please Login or Register  to view this content.