WPS Table Tutorial: Skillfully using the IF function nesting, the students ' grades to grade

In the newly-eliminated examinations and the current high school new curriculum academic level examination, the evaluation of the students is to use the level of evaluation method (general four grades A,b,c,d), that is, the students test results into grades. The following examples illustrate the use of the IF function in the WPS table to nest, to achieve performance and grade conversion process.

First we'll learn about the use of the IF function.

If the function format is: if (test conditions, true value, false values).

The implication is that when the test condition is set up, the True value (the value before the second comma after the first comma) is displayed, and false values (that is, the value after the second comma) are displayed when the test condition is not valid.

For example, entering the function "=if (a2<60,1,2)" in the target cell A2 the value within the cell is less than 60 o'clock in the target cell is 1, when the value in the cell is not less than 60 o'clock the value shown in the target cell is 2.

This shows a number (that is, a numeric value), what if we want to display Chinese characters or other characters? This is simple: just put the desired output into double quotes, and then put it in the appropriate position. If the above function is changed to "=if" (a2<60, "difference", "good"), then when the value within cell A2 is less than 60 o'clock, the target cell displays "bad" and the target cell displays "good" when the value in the cell is not less than 60.

The above example realizes to the numerical two grade division, now carries on the grade evaluation to the student grade needs the multi-level division, in fact, only needs to use the multiple if statement to be nested can realize.

Here is how to use the IF function nesting to four grades of student performance division. In the following illustration, first open the X Class X subject examination rating table, insert a column after column C, enter "Rank" in cell D2, and enter the IF function in cell D3.

Figure 1

(Let's say our grade is divided into: 0~59 is D, 60~74 is C, 76~89 is B, 90~100 is Grade A.) )

The first level if function test condition is "c3<60", if the score is below 60, that is, the value within the C3 cell is less than 60, the correct output "D", when the value in the C3 cell is greater than or equal to 60, nesting the second-tier if statement in the position of the false value. The test condition in the second layer if statement is "c3<75", if the value within the C3 is less than 75, then the output truth "C", if the test condition is not tenable, then the C3 value is greater than or equal to 75, and the third layer if statement is nested in the position of the false value. The test condition in the third level if statement is "c3<90", if the value within the C3 is less than 90, the output Truth "B", if the test condition is not tenable, then the output false value "A". That is, enter in the cell D3: "=if (c3<60," D ", if (c3<," C ", if (c3<90," B "," A "))", enter.

Select the D3 cell and press and hold the fill handle to fill it so that the level conversion of the subject is complete.

Depending on this method, you can convert the levels of other accounts.