Forum Discussion

FrenchyFri27's avatar
FrenchyFri27
Copper Contributor
Feb 13, 2023

Issues Merging Two IF(AND) Formulas Together

Trying to a formula I have in two separate columns to function correctly under one column.

 

Been trying for about an hour but haven't managed to figure it out.

 

Formulas below:

 

Column1:

=IF(OR(ISNUMBER(SEARCH("Spare",K4)),ISNUMBER(SEARCH("Salvage",K4))),"Review","")

 

Column2:

=IF(AND(ISNUMBER(SEARCH("replace",K4)),I4<=0),"Review","")

 

Any help or guidance would be greatly appreciated. 

 

THanks!

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    FrenchyFri27 

    Try this one:

    =IF(OR(OR(ISNUMBER(SEARCH("Spare",K4)),ISNUMBER(SEARCH("Salvage",K4))),AND(ISNUMBER(SEARCH("replace",K4)),I4<=0)),"Review","")
    • FrenchyFri27's avatar
      FrenchyFri27
      Copper Contributor
      You're once again a life-saver. Thank you Patrick2788

Resources