Complex Formula Getting Error..

Giganews Newsgroups
Subject: Complex Formula Getting Error..
Posted by:  cbanks
Date: Thu, 4 May 2006

ok.. I keep getting an error when i add on another piece to this formula..

=IF(ISNUMBER(SEARCH("WARN",J505)),"Warning",IF(ISNUMBER(SEARCH("PSSNAP",N505)),"Sales",IF(ISNUMBER(SEARCH("WARN",L505)),"Warning",IF(ISNUMBER(SEARCH("2699",L505)),"Warning",IF(ISNUMBER(SEARCH("4004",L505)),"Warning",IF(ISNUMBER(SEARCH("2036",L505)),"Warning",""))))))

I think it may be because im adding my seventh level so to speak but im not
sure.. I need to add more conditions to this formula like below..

=IF(ISNUMBER(SEARCH("WARN",J505)),"Warning",IF(ISNUMBER(SEARCH("PSSNAP",N505)),"Sales",IF(ISNUMBER(SEARCH("WARN",L505)),"Warning",IF(ISNUMBER(SEARCH("2699",L505)),"Warning",IF(ISNUMBER(SEARCH("4004",L505)),"Warning",IF(ISNUMBER(SEARCH("2036",L505)),"Warning",IF(ISNUMBER(SEARCH("8010",L505)),"Warning",""))))))

Is there anyway to keep adding to this function its giving me an error? or
is there another way i need to go about this? I have some minor VBA
experience but dont think i can write all the code.

Replies