Current location - Training Enrollment Network - Mathematics courses - Excel 2007 I error function tutorial
Excel 2007 I error function tutorial
After entering data in Excel, you need to use function statistics data, among which iferror function is commonly used. If you don't know how to use it, please come and study together. The following is the function tutorial of excel2007 iferror that I shared for everyone to read and learn.

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? .