Forum Discussion

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 ...

excel

Formulas and Functions

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"))