Example of using the if function in excel

1. In excel, select the cell to be output, and click "Insert"> "function"> "logic"> "IF" at the top of the excel file, as shown in the following figure.

2. Now a function parameter dialog box is displayed. Here we can see that the first (logical_test) indicates the condition, and the other two are the result of the condition judgment. We click the first yellow box to process the condition, as shown in the following figure.

3. now I have searched for the failed score in cell A2, that is, a2 <60. You can set the value_if_true parameter to fail, vale_if_false = pass (meaning the return value is true or false ).

4. After clicking it, the selected cell will appear. Now we are referring to the cell with a formula, and then pull it when there is an entity + number.

5. However, you may ask, isn't the score still passing, good, or excellent? How can I determine it? In fact, it is very simple, that is, you can use the IF function continuously. It is called "IF function nesting" in terms ". For example, if I want to pass the 60-70 display, the 70-80 display is good, and the 80 + display is excellent.

6. Now, in the same way as in the third line, click in if settings, and set logical_test to a2 <70 to find value_if_false.

7. In the same way, the settings are good and excellent. If you want to continue to score points later, you can also continue nesting, so the third line should not be excellent.

8. Similarly, place the cursor in the lower-right corner of the first result, and double-click it to display all the results.