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

=IF(ISNUMBER(SEARCH("WARN",J505)),"Warning",IF(ISN UMBER(SEARCH("PSSNAP",N505)),"Sales",IF(ISNUMBER(S EARCH("WARN",L505)),"Warning",IF(ISNUMBER(SEARCH(" 2699",L505)),"Warning",IF(ISNUMBER(SEARCH("4004",L 505)),"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(ISN UMBER(SEARCH("PSSNAP",N505)),"Sales",IF(ISNUMBER(S EARCH("WARN",L505)),"Warning",IF(ISNUMBER(SEARCH(" 2699",L505)),"Warning",IF(ISNUMBER(SEARCH("4004",L 505)),"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.