By Nate Moore, CPA, MBA, CMPE
If you've ever presented a spreadsheet that you thought was perfect but were surprised with a "#DIV/0!" error or an "#N/A" error message like the spreadsheet in Figure 1, this article is for you. Excel has an "IFERROR" function that can automatically replace error messages with a message of your choice.
Not a Member?