CODEWITHSUNDEEP
excel-formula
LBJ
LBJ

Reputation: 1

getting false result when it should return 1 or 0

=IF(ISNUMBER(SEARCH("consumer", I4)),IF(ISNUMBER(SEARCH("compliance", I4))*AND(L4="Complete",AND(P4="Yes",Q4="No")),1,0))

I am trying to search a specific column for two values and then compare another two columns to get a return value as 1 or 0 but I am getting a "false"

Upvotes: 0

Views: 37

Answers (1)

Scott Craner
Scott Craner

Reputation: 152575

That is not how you use AND()

IF(AND(OR(ISNUMBER(SEARCH("compliance",I4)),ISNUMBER(SEARCH("consumer", I4))),L4="Complete",P4="Yes",Q4="No"),1,0)

Upvotes: 1

Related Questions