Most of the times, we use Excel to crunch numbers, but what a lot of people don’t know is that Excel is a very effective tool to crunch text as well.
We can use Excel to clean text fields, extract specific information from text fields, or join text fields together.
Working with errors in Excel using IFERROR and ISERROR functions (example with screenshots and video tutorial)
We have previously seen the IF function and how it worked. Now we will talk about how to work with errors using IFERROR and ISERROR.
Let’s start with IFERROR. IFERROR is actually an extension to the IF function. It tells Excel what to do with other formulas when it can’t find the answer or when it returns an error.
Today I’m going to talk about IF formulas. IF functions are logical functions, meaning that any formula you write with an IF function will return one value if a condition is true and another value if the condition is false.