+ Reply to Thread
Results 1 to 4 of 4

Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE!

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    158

    Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE!

    I am using the formula below to calculate a date value:

    =IF(K2<=45,A2,A2+(K2-45))

    The result when applying this to the entire column in some of the cells is: #VALUE!

    I would like the cell to remain blank when #VALUE! is the result and am trying to add an IFERROR (or ISERROR) part to the original formula, but have been unsuccessful.

    Any help with this would be GREATLY APPRECIATED!
    Last edited by Hedy; 01-13-2016 at 12:12 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,268

    Re: Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE

    Try

    =IFERROR(IF(K2<=45,A2,A2+(K2-45)),"")


    =IFERROR( your formula,"")

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,445

    Re: Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE

    =iferror(if(k2<=45,a2,a2+(k2-45)),"")

  4. #4
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    158

    Re: Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE

    OMG! That worked. I must have tried 30 different ways! Thank you so very much!

+ 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. adding to existing formula
    By jryoung91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2015, 09:39 AM
  2. Adding to an existing formula !!!!!!!!!
    By hlb129 in forum Excel General
    Replies: 3
    Last Post: 02-10-2015, 08:02 AM
  3. Adding another formula to an existing one
    By JakeMann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2014, 08:22 AM
  4. Adding to an Existing Formula
    By jcl6543 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2014, 12:58 AM
  5. adding to existing formula
    By wwoody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2013, 03:25 AM
  6. Help adding Iferror to existing formula
    By rwmeis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 12:33 PM
  7. Adding to 2 existing formula
    By cmackay1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2012, 05:14 PM

Tags for this Thread

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