+ Reply to Thread
Results 1 to 2 of 2

Adding IFERROR Statement to a Formula

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    73

    Adding IFERROR Statement to a Formula

    I have the following code:

    Please Login or Register  to view this content.
    I need to be able to add IFERROR to it, however, I am having trouble doing this. It needs to resemble something like the following:

    Please Login or Register  to view this content.
    This isn't working and I can't figure out why after reading up on the error messages online. Any advice?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Adding IFERROR Statement to a Formula

    I think you gotta double the quotes in VBA. So...

    Please Login or Register  to view this content.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. [SOLVED] Adding IFERROR to a formula help
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2018, 03:51 AM
  2. [SOLVED] Adding IfError To RC Format Formula
    By jo15765 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2017, 09:51 PM
  3. [SOLVED] Adding 2nd criteria to SUM-IF-IFERROR-MONTH formula
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2017, 10:14 PM
  4. [SOLVED] Adding IFERROR to a formula to get rid of #####
    By Hedy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-08-2016, 03:24 PM
  5. [SOLVED] Help on adding an IFERROR/IF function to an existing formula.
    By Albert Dirk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-23-2016, 07:16 AM
  6. [SOLVED] Adding IFERROR IF MATCH Formula to each row
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:47 PM
  7. Help adding Iferror to existing formula
    By rwmeis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 12:33 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