Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unknown Formula Error
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown formula - not in help | Excel Worksheet Functions | |||
unknown #value error | Excel Discussion (Misc queries) | |||
Unknown Formula: R[-1]c/r[4]c[-6] | Excel Discussion (Misc queries) | |||
Unknown Formula | Excel Discussion (Misc queries) | |||
Unknown Error | Excel Discussion (Misc queries) |