Feb 13 2023 10:12 AM
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!
Feb 13 2023 10:59 AM
Try this one:
=IF(OR(OR(ISNUMBER(SEARCH("Spare",K4)),ISNUMBER(SEARCH("Salvage",K4))),AND(ISNUMBER(SEARCH("replace",K4)),I4<=0)),"Review","")
Feb 13 2023 11:32 AM