Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Some notes: (1) SUM (C5: F5) is not equal to zero is the formal written SUM (C5: F5) <> 0, in EXCEL can be omitted <> 0; (2) "," that the contents of the string is empty, so the results of the implementation in the cell do not show any characters.
With the above example, if a good understanding, we can easily function will be applied to the IF wider areas. For example, in the results table, depending on the distinction between qualified and unqualified success. Now we have to a certain class of English as an example to specify the use of results.
The results of a class as shown in Figure 6, in order to make a final comprehensive evaluation, we set up in accordance with the average results to determine whether the student qualified rules. If the average sub-branches that more than 60 hours is qualified, otherwise recorded as failed. According to this rule, we have to write a comprehensive evaluation of the formula (in cell B12 as an example): = IF (B11> 60, "qualified", "unqualified") Syntax as if the value of cell B11 is greater than 60, while the second parameter that is displayed in cell B12 the word qualified, otherwise the implementation of the third parameter that is displayed in cell B12 the word failure. Comprehensive assessment in the column can be seen out as a result of C students were divided into 54 sub-branches, comprehensive assessment for the failure. The rest are qualified. |
