+ Reply to Thread
Results 1 to 4 of 4

Nested IFISERROR Arguments

  1. #1
    Forum Contributor
    Join Date
    10-09-2015
    Location
    Canada
    MS-Off Ver
    Office Home and Student 2021 for Mac
    Posts
    170

    Nested IFISERROR Arguments

    Hi all,

    I'm currently trying to figure out a way to implement nested IFERROR/IF(ISERROR) statements into my formulas, but am having some difficulty.

    Essentially, I would like the cell that contains the formula to be blank when the cell that the formula is referencing is blank.

    I've attached a workbook to (hopefully) provide more clarity.

    Any suggestions are greatly appreciated.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Nested IFISERROR Arguments

    Add this before your formula in H3:
    IF(AND(C3="",D3=""),"",
    And another closing parenthesis in the end.

    But I guess you'd be better off with a VLOOKUP instead of all those IFS.

    Good luck!

  3. #3
    Forum Contributor
    Join Date
    10-09-2015
    Location
    Canada
    MS-Off Ver
    Office Home and Student 2021 for Mac
    Posts
    170

    Re: Nested IFISERROR Arguments

    Quote Originally Posted by Estevaoba View Post
    Add this before your formula in H3:
    IF(AND(C3="",D3=""),"",
    And another closing parenthesis in the end.

    But I guess you'd be better off with a VLOOKUP instead of all those IFS.

    Good luck!
    Oh awesome, thanks! This worked like a charm. I definitely here what you're saying about the VLOOKUP.

    D.

  4. #4
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Nested IFISERROR Arguments

    You're welcome! Glad to help.
    Thanks for the feedback and the rep points added.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro for Nested IF - Too Many Arguments
    By dizjackson in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2019, 08:03 AM
  2. Too many Nested arguments > 7
    By NickTY in forum Office 365
    Replies: 5
    Last Post: 11-15-2018, 10:22 AM
  3. [SOLVED] Help with Nested IF arguments, please
    By KWiseman in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-13-2018, 04:23 AM
  4. [SOLVED] Nested IFISERROR Question...
    By hambly in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-14-2013, 09:52 AM
  5. Need a Nested IF with 12 Arguments
    By daz_uk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2010, 08:54 AM
  6. Going beyond 7 Nested If Arguments
    By Supdem in forum Excel General
    Replies: 2
    Last Post: 08-05-2009, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1