Forum Discussion
Kristin1712
Oct 16, 2023Copper Contributor
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 inv...
HansVogelaar
Oct 16, 2023MVP
Let's say that E6 currently contains the formula
=D6-$G$1
Change it to
=IFERROR(D6-$G$1, "Check date")
- Kristin1712Oct 17, 2023Copper ContributorThis 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.