Issues Merging Two IF(AND) Formulas Together

Copper Contributor

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!

2 Replies

@FrenchyFri27 

Try this one:

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