Creating & Naming a Nested IF(ISERROR(SEARCH)) Statement
Posted by Kerry on August 02, 2001 9:26 AM
I have over 30 IF(ISERROR(SEARCH)) Statements that look like this:
IF(ISERROR(SEARCH("Subscriber port is not assignable",K2)),0,1).
I would like to nest them into one column. I have tried
=IF(ISERROR(SEARCH("Subscriber port is not assignable",K2)),
IF(ISERROR(SEARCH("ActivationRequestMessage",K2)),
IF(ISERROR(SEARCH("Subscriber port does not exist",K2))
,IF(ISERROR(SEARCH("Requested Mux port does not exist",K2))
,IF(ISERROR(SEARCH("Translation restricted",K2)),
IF(ISERROR(SEARCH("Translation failure",K2))
,"","Translation Failure"),"Translation Restricted"),
"Inventory not built in !ntegrator or built wrong in NCON")
,"Inventory not built in !ntegrator or built wrong in NCON"),
"Not Translated or Assigned"),"WLI")
Then placed this Function into cell V2 and Named it Fallout1.
I then repeated this 3 more times and saved it as Fallout2, Fallout3 and Fallout4.
I then tried the function =IF(Fallout1,Fallout2,Fallout3,Fallout4)which returns #VALUE ERROR.
Can anyone help with this?