Healthcare Business Management Association - HBMA
Leading the Business of Healthcare Login
Handling Excel's "IFERROR"
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?

Click here to purchase an annual subscription to our Billing Journal! Click here to purchase an annual
subscription to our Billing Journal!
 
Tell me more! Learn about our member benefits... Tell me more! Learn about
our member benefits...
 
Join Now! Gain immediate access to all online membership benefits. Join Now! Gain immediate access
to all online membership benefits.
Non Members can download one copy of Billing - click here to download yours today! Non Members can download one copy of Billing.
Click here to download yours today!
 
Email the membership department. Email the membership department.

Welcome, Please Sign In
Username:
Password:
Remember Login:

 Return to Issue Index