How to fill in the conditions of the iferror function.
The iferror function is a very useful function in Excel, which can catch and deal with errors during the calculation process, so as to avoid the stop or interruption of the formula due to errors. The use of the iferror function is very simple, and we will explain it in detail below.
1. Grammar. The syntax of the iferror function is very simple, with two arguments.
iferror(value, error value).
The first parameter, the value, refers to the formula that we normally use, such as a1 b1.
The second parameter, the error value, refers to the value to be returned when the calculation process is incorrect. For example, the formula returns n a and value!In this case, we specify that the formula returns "error" or "no data".
2. Example demonstration.
1.Suppose we want to calculate the value of cell A1 divided by the value of cell B1 and store the result in cell C1. If the divisor is 0, the "Error" text is returned. We can use the following formula:
iferror(a1/b1, "Wrong")
2.Suppose we want to query the number of bonuses that have been paid to employees according to the employee roster, and if we can't find it, we can return "no result", we can use the following formula:
iferror(vlookup(a3,g:i,3,false),"No results")
3. Precautions.
1.The iferror function can be used to catch and deal with errors in Excel, such as dividing by 0, finding errors, invalid formulas, etc. 2.The first parameter of the iferror function is the formula we want to calculate, and the second parameter is the value to be returned if there is an error in the calculation process. 3.When using the iferror function, you should pay special attention to the setting of the second parameter, and select the appropriate error value according to the actual situation, so that the formula can more accurately reflect the actual situation. 4.The way to use the iferror function is simple, you just need to put the formula in the iferror function. However, it is important to note that the iferror function can only handle a single error, not multiple errors.