IFERROR Problems

JO Ross

I am trying to enter a formula that returns a 1 or 0 if the word "accepted" is in a reference cell. I am ultimately trying to run this formula for 3 separate cells, and if the sum of those cells is 3, then the general status column would turn to "Complete" and Health would turn to Green. Here is the formula I found, but it does not seem to work.

=IFERROR(IF(SEARCH("Accepted",[Signed Subcontract / PO Status]2),1),0)

I have also tried the following:

=IF(ISNUMBER(SEARCH("Accepted",([Signed Subcontract / PO Status]2)),"1","")

 

=IF(AND(LEFT([Signed Subcontract / PO Status]2)="Accepted","1"

 

=IFERROR(IF(SEARCH(“Accepted”, [Signed Subcontract / PO Status]2,1)>0,1,0),””)

 

=IFERROR(SEARCH("Accepted", [Signed Subcontract / PO Status]2:1, 2, false), " ")

Jeff Hoelzel

If you really want to use the IFERROR formula and it would not be affected by the 3 other cells mentioned: =IFERROR(IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0),"")

You could just use: =IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0)

Jeff Hoelzel

If you really want to use the IFERROR formula and it would not be affected by the 3 other cells mentioned: =IFERROR(IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0),"")

You could just use: =IF([Signed Subcontract / PO Status]@ROW="Accepted",1,0)

JO Ross

The second one worked great! I guess I was trying too hard. Thanks!