How do I use the IF function in Excel?

If function operation method

Open the required software Excel, directly in the desired cell data =if (conditions, satisfies the condition the result, does not satisfy the condition the result, certainly the entire if statement is supports the nesting, for instance possibly is =if (condition 1, satisfies the condition the result, if (condition 2, satisfies the condition the result, does not satisfy the condition the result))!

Open Excel, open your data document, click "Insert" on the toolbar in the cell where you want to output the data-"function"-"logic"-"IF", then click OK.

Click OK will pop up a box, the first one to show the condition, the following two are the results of the judgment condition. Click on the small mark of the place, select the data, generally we do not have to select all the data, just select one of the inside can be.

Small Series I choose A2, we are using if to judge the math and failure. If the condition is <60, the indication is not tenable, the show fails, otherwise the words remaining are the pass grade.

Click OK, we can see the result of the judgment, put the mouse after the first result, when the mouse into "+", we double-click it can get all the results.

However, you will ask small knitting, the score is not a pass, good or excellent? How am I supposed to judge? In fact, it is very simple that you use if in a row, the term is called "if function nesting." For example I want 60-70 show pass, 70-80 show good, 80 points above show excellent

We then set a 60-70-point display Pass, and then again, the third line, and then click If, nested.

The same method, set good and excellent, if you want to continue to the next point, you can continue to nest, then the third line do not write excellent.

Similarly, we put the mouse on the first result in the lower right corner of the "+", double-click to show the full results.

Other cases

Logical_test represents any value or expression that evaluates to TRUE or FALSE. For example, a10=100 is a logical expression, if the value in cell A10 is equal to 100, the expression is TRUE, or FALSE. This parameter can use any comparison operator.

Workaround:

Logical_test represents any value or expression that evaluates to TRUE or FALSE. For example, a10=100 is a logical expression, if the value in cell A10 is equal to 100, the expression is TRUE, or FALSE. This parameter can use any comparison operator.

The value returned when Value_if_true Logical_test is true. For example, if this argument is a text string "Budget" and the Logical_test parameter value is TRUE, the IF function displays the text "budget." If Logical_test is TRUE and value_if_true is empty, this argument returns 0 (0). If you want to display true, use the logical value TRUE for this parameter. Value_if_true can also be other formulas.

Value_if_false the value returned when Logical_test is false. For example, if this argument is a text string "out of budget" and the Logical_test parameter value is FALSE, the IF function displays the text "out of budget." If Logical_test is false and the Value_if_false is ignored (that is, the value_if_true does not have a comma), the logical value is returned false. This argument returns 0 (0) If Logical_test is FALSE and Value_if_false is empty (that is, a comma after the value_if_true followed by a closing parenthesis). Value_if_false can also be other formulas.