When working with data tables and formulas, its common to come across errors. There are a number of ways of dealing with errors one of which is to use the IFERROR formula to identify an error and deal with it in a controlled manner. To demonstrate the application of this formula we'll need to create an error. The simplest way to do this is with the formula =1/0 which will generate the #DIV/0 error as shown here. The IFERROR function has two arguments, both mandatory. The first, value, is the part of the function that will be tested to see if it returns an error. The second argument, value_if_error, is the argument that is returned if the value returns an error. For example, if we set the first argument, value, to 1/0 and the second argument, value_if_error to "Error", the formula will return "Error" because 1/0 returns the #DIV/0 error as described earlier in the article. returns...
