Forum Discussion
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: =I...
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