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: =I...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 13, 2023

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
    Feb 13, 2023
    You're once again a life-saver. Thank you Patrick2788