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

1. ## 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!

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

Try

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

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

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

4. ## 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!

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