Forum Discussion
Excel
I am having trouble with this step in using IFERROR. How to Nest an IFERROR function with the formula. Select cell E6 on the Accounts Aging sheet and review the formula. The formula subtracts the invoice date from today’s date in cell G1. Nest an IFERROR formula to display Check date. instead of a standard error message. Copy the IFERROR formula to cells E7:E20.
I am trying, but it still isnt coming our correctly. Help anyone?
4 Replies
Let's say that E6 currently contains the formula
=D6-$G$1
Change it to
=IFERROR(D6-$G$1, "Check date")
- This worked once I changed it a little. I just had to put "$G$1-D6". When I put it the other way it was populating a negative number.
- Can you please attach a sample screenshot or a file here?
I will put it below. Lets see if this helps SanthoshKunder
