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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unknown Formula Error
There were a lot of unecessary parentheses, which I removed. There was an
error with the parentheses of the 2nd Or function which I fixed. Otherwise, the below is the same as what you posted: =IF(OR(ISNUMBER(SEARCH(LEFT(H2,5)&"+",X2)),ISNUMBE R(SEARCH(RIGHT(H2,5)&"+",X2)), ISNUMBER(SEARCH("+"&LEFT(H2,5),X2)),ISNUMBER(SEARC H("+"&RIGHT(H2,5),X2))),"C2",IF(OR(X2=LEFT(H2,5),X 2=RIGHT(H2,5),ISNUMBER(SEARCH(LEFT(H2,5),X2)),ISNU MBER(SEARCH(RIGHT(H2,5),X2)),AND(H2="",X2="")),"C" ,IF(H2="","FP","FN"))) Greg "Shaunna H." wrote: =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 |
Reply |
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) |