#VALUE ERROR on formula

[excelbrands]

Can you look at the attached and see why I am getting this error? I am combining formulas and I am sure I am missing something. I hid the columns that are not being referenced. I basically want to score accounts (1,2,3). Some rows work and some throw that #VALUE! error.

 

[steve the fish]

Would be able to see it if you provided the formula.

 

[excelbrands]

Would be able to see it if you provided the formula.

=IF(AND(M3>0,X3>(TODAY()-90))=TRUE,"1",IF((OR(IFERROR(FIND("competitor 1",E3,1),"0"),IFERROR(FIND("competitor 2",E3,1),"0"),IFERROR(FIND("competitor 3",E3,1),"0"),IFERROR(FIND("competitor 4",E3,1),"0"),IFERROR(FIND("competitor 5",E3,1),"0"),IFERROR(FIND("competitor 6",E3,1),"0"),IFERROR(FIND("competitor 1",T3,1),"0"),IFERROR(FIND("competitor 2",T3,1),"0"),IFERROR(FIND("competitor 3",T3,1),"0"),IFERROR(FIND("competitor 4",T3,1),"0"),IFERROR(FIND("competitor 5",T3,1),"0"),IFERROR(FIND("competitor 6",T3,1),"0")))=TRUE,"2","3"))

 

[steve the fish]

The OR is not going to like "0" but will be happy with 0 so remove those quotes.

 

[steve the fish]

You could try this:

=IF(AND(M3>0,X3>(TODAY()-90)),1,IF(OR(ISNUMBER(FIND("competitor "&{"1","2","3","4","5","6"},E3)),ISNUMBER(FIND("competitor "&{"1","2","3","4","5","6"},T3))),2,3))

 

[excelbrands]

The OR is not going to like "0" but will be happy with 0 so remove those quotes.

@steve the fish THANK YOU SO MUCH!!! It worked!!!