How to use the computer first-level if function-excel-php.cn

How to use the computer first-level if function

angryTom

Release： 2019-10-24 13:45:54

Original

16697 people have browsed it

How to use the computer-level if function

The IF function is one of the most commonly used functions in Excel. Today Let me explain to you the use of IF function.

Recommended tutorial: excel tutorial

Grammar structure

=IF(条件, 条件成立时的值, 条件不成立时的值)

Copy after login

For example, we enter ## in cell A2 #IF(2>1, "2 is greater than 1", "impossible")

How to use the computer first-level if function

When you hit Enter, the content of A2 becomes:

How to use the computer first-level if function

We all know that 2 is greater than 1, so according to its grammatical structure, the program will execute the value when the condition is true. Then let’s change the condition to not true. Let’s try it. Try IF(

2>3, "2 is greater than 1", "impossible"):

How to use the computer first-level if function

How to use the computer first-level if function ## Sure enough , the following value is executed when the condition is not met.

The following is a small application to show the use of the if function:

Above we use if The function determines the student's score. If it is greater than or equal to 60, it is considered qualified, otherwise it is considered unqualified.

IF function can be used nested, we can change this formula to let it judge more results!

How to use the computer first-level if function

How to use the computer first-level if function This statement, when it is judged that the score is greater than or equal to 60, the second if function will be executed to judge again whether it is greater than or equal to 80 , returns excellent if established, otherwise returns qualified.

I hope you will practice more, practice makes perfect.

The above is the detailed content of How to use the computer first-level if function. For more information, please follow other related articles on the PHP Chinese website!