+ Reply to Thread
Results 1 to 5 of 5

Iferror + if statement

  1. 04-23-2019, 11:19 AM #1
    eggselent
    eggselent is offline
    Registered User
    Join Date
    12-26-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel for 365
    Posts
    62

    Iferror + if statement

    I have the below formula...

    =IF($F$3=$E$3,IF($C12=$A12,$E12))

    I’d like to add an IFERROR “-“to this to eliminate NA values.

    Can’t seem to figure out how. Not included here is a defense to another workbook after the =, but I didn’t think that mattered.
    Reply With QuoteRegister To Reply
  2. 04-23-2019, 11:22 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,438

    Re: Iferror + if statement

    Maybe this?

    =IFERROR(IF($F$3=$E$3,IF($C12=$A12,$E12)),"-")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-23-2019, 11:40 AM #3
    eggselent
    eggselent is offline
    Registered User
    Join Date
    12-26-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel for 365
    Posts
    62
    Quote Originally Posted by AliGW View Post
    Maybe this?

    =IFERROR(IF($F$3=$E$3,IF($C12=$A12,$E12)),"-")
    Thanks for the reply. I still get an NA
    Reply With QuoteRegister To Reply
  4. 04-23-2019, 11:45 AM #4
    eggselent
    eggselent is offline
    Registered User
    Join Date
    12-26-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel for 365
    Posts
    62
    Quote Originally Posted by eggselent View Post
    Thanks for the reply. I still get an NA
    Never mind seems the NA is the value in the other file. Thanks for the help. Guessing no way to work around this
    Reply With QuoteRegister To Reply
  5. 04-23-2019, 11:56 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,438

    Re: Iferror + if statement

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. iferror statement not working
    By strollox in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2018, 11:34 PM
  2. [SOLVED] how to wrap iferror in my if statement in a table
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2018, 10:03 AM
  3. =SUM(B93:B113)/I92 with an IFERROR statement, help!
    By Niedermayer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-28-2016, 02:24 PM
  4. Please help with and IF statement including IFERROR
    By justinr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2015, 06:21 PM
  5. [SOLVED] Please help with an IF statement including IFERROR
    By justinr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2015, 05:47 PM
  6. IFERROR Statement Help/Update...
    By kzemaitis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-18-2014, 06:32 PM
  7. [SOLVED] IFERROR Statement in VBA for date
    By Maxy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2013, 08:44 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1