Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
3, the application of multi-layer nested function In the above example, we only qualified success into a simple and unqualified, in the practical application, the results are usually a number of levels, such as excellent, good, medium, passing, failing and so on. There are ways to distinguish between a one-time right? Can use the multi-nested approach to achieve. The above cases are still as an example, we set the rules for comprehensive assessment when the subjects at an average of more than 90 hours, assessed as excellent. Shown in figure 7.
According to this rule, we have to write a comprehensive evaluation of the formula (in cell F12 for example): = IF (F11> 60, IF (AND (F11> 90), "excellent", "Qualified"), "failed") Syntax as if the value of cell F11 is greater than 60, while the second parameter, where for the nested function, continue to determine the value of cell F11 is greater than 90 (in order to let everyone understand what the application AND function, written AND (F11> 90), can actually write only F11> 90), if in cell F12 to display the word excellent, does not meet display the word qualified, if the value of F11 did not meet the above requirements, then the implementation of the third parameters in cell F12 to display the word failure. Comprehensive assessment in the column can be seen out as a result of F students were divided into 92 sub-branches, comprehensive assessment for the best. (C) calculated in accordance with the conditions IF function in understanding the use of the method, let us look at the Excel similar can be provided to analyze the data in a condition of the other function. For example, to calculate a range in the text string or the number of figures, you can use the COUNTIF worksheet function. If we were in the range of a text string or the number of summation, you can use the SUMIF worksheet function. SUMIF functions on the trigonometric functions in mathematics and has done more in detail. COUNTIF here focuses on the application. COUNTIF can be used to calculate a given region to meet the specific conditions of the number of cells. For example, in the results table to calculate each student's course made a few good results. Obtained in the wage table in all the basic wage of more than 2,000 employees. Grammatical form of COUNTIF (range, criteria). Range for the calculation of which need to meet the conditions in which the number of cell range. Criteria to determine which cells will be taken into account the conditions, which may take the form of digital, or text expression. For example, the condition can be expressed as 32, "32", "> 32", "apples". 1, results There are still examples of the above-mentioned results indicate a number of applications. We need to calculate is: every student of the course made a number of outstanding results. Rules for the performance of more than 90 minutes to do good in mind. Is shown in Figure 8
= COUNTIF (B4: B10, "> 90") Interpreted as a syntax to calculate the range B4 to B10, that is, the subjects jarry results in the number of values greater than 90 cells. Excellent column in the gate count can be seen excellent jarry for 2 doors. Can also be followed by others to see. |
