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!
Bookmarks