Not sure when it happened, but a recent update to Excel has enabled the IFERROR function to handle spill errors.
Tag Archives: error messages
Excel Links and Deleted and Inserted Rows
How to avoid #REF! errors
When linking to another sheet, a deleted row can often cause a #REF! error. You can use the INDEX function to avoid these errors.
Handling Text in Calculation Cells in Excel
If you need to do mathematical calculations on cells that may contain numbers or text, then you can use the IFERROR function to ignore the text.
Avoiding Excel’s Blank look
Using the ISBLANK function
When building formulas you sometimes need to identify a blank cell. Let’s say you use a VLOOKUP function. If the cell you are looking up is blank it can cause the #N/A error.
Beware Excel’s Merge and Center format
Purge the Merge
Ever had an error message which stated that you “Cannot change part of a merged cell”?
Well the merge format is the culprit. The Merge and Center icon on the Home ribbon is commonly used to format headings to make them look good by centering a heading across the cells below it.