Excel2007 iferror function tutorial:
Iferror function uses step1:The syntax of if error function is IFERROR(value, value_if_error), which contains two parameters, where value refers to the parameter that needs error checking. Value_if_error refers to the information returned when there is an error in formula calculation. When there is no error in formula calculation, the function will return the calculated value, and when there is an error, an error message will be returned.
If you use the error function, step 2: Let's give a simple example to illustrate the use of the iferror function. Everyone knows that there will be errors when divided by zero. We use the IFERROR function to return the calculated value when the calculation is normal, otherwise a prompt message will appear? Is there a mistake in the calculation? . We use IFERROR( 10/5, "Error in calculation").
If the error function uses step 3: There is no error in the calculation after execution, we get the operation result of 2. If there is an error in the calculation, we will get an error message? Is there a mistake in the calculation? . For example, we deliberately set the divisor to zero.
Iferror function The error types that can be determined by using Step 4: If error function are: #N/A, #VALUE! 、REF! 、DIV/0! 、NUM! , name? Or #NULL! . Let's give an example to demonstrate. For example, to calculate the total score of students. If the score is normal, we will calculate the sum of the scores. If there is an error, we will get a prompt message? Some grades were entered incorrectly? . We enter the formula IFERROR(SUM(A2, B2), "Some grades are not entered correctly").
If the wrong function is used, step 5: We see that the score is filled in normally and get the total score, but if there is an error, there is an error message prompt? Some grades were entered incorrectly? .