Your Excel formulas can occasionally produce errors that don’t need fixing. However, these errors can look untidy and, more importantly, stop other formulas or Excel features from working correctly. Fortunately, there are ways to hide these error values.
Hide Errors with the IFERROR Function
The easiest way to hide error values on your spreadsheet is with the IFERROR function. Using the IFERROR function, you can replace the error that’s shown with another value, or even an alternative formula.
In this example, a VLOOKUP function has returned the #N/A error value.
This error is due to there not being an office to look for. A logical reason, but this error is causing problems with the total calculation.
The IFERROR function can handle any error value including #REF!, #VALUE!, #DIV/0!, and more. It requires the value to check for an error and what action to perform instead of the error if found.
In this example, the VLOOKUP function is the value to check and “0” is displayed instead of the error.
Read the remaining 26 paragraphs
from How-To Geek https://ift.tt/32CZ9tu
No comments:
Post a Comment