Forum Discussion

Virock's avatar
Virock
Copper Contributor
Aug 01, 2023

Nested IFs Causing "Problem With Formula" Error

Excel is not recognizing my formula and says "there's a problem". I'm sure it's something simple and I have become blind to it. I need a second set of eyes.

The spreadsheet itself is not my IP. I can make a dummy spreadsheet if necessary.

 

 

=IF(EXACT(L4, "none"),
    IF(EXACT(N4, "none"),
        "NOT FOUND",
        IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!N4, Transmitters!A:A, Transmitters!H:H)))
            "No",
            "Yes")),
    IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!L4, 'II-Kits'!A:A, 'II-Kits'!I:I)))
        "No",
        "Yes"))

 

 

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 01, 2023

    Virock 

    You're missing the commas after the ISNUMBER function.

    =IF(EXACT(L4, "none"),
    IF(EXACT(N4, "none"),
        "NOT FOUND",
        IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!N4, Transmitters!A:A, Transmitters!H:H))),
            "No",
            "Yes")),
    IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!L4, 'II-Kits'!A:A, 'II-Kits'!I:I))),
        "No",
        "Yes"))

Resources