Unknown Formula Error
Can you explain *in words* what you're trying to do?
What's the significance of the numbers and the location of the "+" sign?
--
Biff
Microsoft Excel MVP
"Shaunna H." <Shaunna wrote in message
...
=IF((OR((ISNUMBER(SEARCH(LEFT(H2,5)&"+",X2))),((IS NUMBER(SEARCH(RIGHT(H2,5)&"+",X2)))),
((ISNUMBER(SEARCH("+"&LEFT(H2,5),X2)))),((ISNUMBER (SEARCH("+"&RIGHT(H2,5),X2)))))),"C2",IF((OR(X2=(L EFT(H2,5))),(X2=(RIGHT(H2,5))),(ISNUMBER(SEARCH(LE FT(H2,5),X2))),(ISNUMBER(SEARCH(RIGHT(H2,5),X2))), (AND(H2="",X2=""))),"C",IF(H2="","FP","FN")))
I am trying to evaluate a very complicated scoring formula, as seen above.
Example:
If cell H2 contains "abc12 def34" and cell X2 contains "abc12+", "def34+",
"+abc12", or "+def34", then Z2=C2
If cell X2 contains "abc12" AND "def34", OR X2 is blank AND H2 is blank,
then Z2=C
If H2 is blank Z2=FP
Else Z2=FN
|