Forum Discussion
FrenchyFri27
Feb 13, 2023Copper Contributor
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!
- Patrick2788Silver Contributor
Try this one:
=IF(OR(OR(ISNUMBER(SEARCH("Spare",K4)),ISNUMBER(SEARCH("Salvage",K4))),AND(ISNUMBER(SEARCH("replace",K4)),I4<=0)),"Review","")
- FrenchyFri27Copper ContributorYou're once again a life-saver. Thank you Patrick2788