How to combine multiple conditions in the if function

Understand the syntax of the IF function

IF(logical_test, [value_if_true], [value_if_false]), where logical_test is the expression of the logical test; value_if_true is the return result if the test result is true Value, value_if_false is the return value if the test result is no.

Related recommendations: "excel basic tutorial"

New worksheet , and enter the data

First, create a new excel worksheet and enter the student's student number, name, grades and other basic information into the form, as shown in the figure.

Set the judgment rules

Implementation function: according to the student's score, the if function can be used to automatically judge the score, greater than or equal to 90 points is considered "excellent"; greater than or equal to 80 points, less than 90 points is considered "good"; greater than or equal to 70 points, less than 80 points is considered "medium"; greater than or equal to 60 points, less than 70 points is considered "passed"; less than 60 points is considered "passed" "Difference".

Enter the first layer IF function

Enter the function =if in cell E4 (D4>=90,"Excellent ",), which means that if the various values ​​in cell D4 are greater than or equal to 90, then "excellent" will be output; if the value in cell D4 is less than 90, the value of the second if function will be output.

Note:

1. When entering the content of the function, you need to switch the input method to English format;

2. The expression for greater than or equal to is >=;

3. Nest the functions from high to low according to the score.

Nest the IF function and design the formula

Press = (IF(D4>=90,"Excellent", IF(D4>=80,"Good",IF(D4>=70,"Medium",IF(D4>=60,"Qualified",IF(D4=80,"Good",IF(D4>=70,"Medium",IF(D4>=60,"Qualified","Poor")))) ) expression and enter the complete function. After entering the expression, click the Enter key. At this time, you will find that the content in cell D4 changes to the word "qualified".

Note:

1. When entering brackets, enter the left bracket and the right bracket at the same time, so that there will be no problems with the number and level of brackets. Developing good habits will also be helpful for learning other functions in the future.

2.if The value range to be determined must be complete. In the case, all values ​​greater than 90 and less than 60 are included.

Copy the formula to other cells

Select cell D4, place the mouse in the lower right corner of the cell, hold down the left mouse button until the mouse arrow changes to " ", and pull the mouse down to the position of D17. At this time, you can It is found that the contents of all cells have been generated, as shown in the figure.

For more Excel-related technical articles, please visit the Excel Basic Tutorial Columnlearn!

The above is the detailed content of How to combine multiple conditions in the if function. For more information, please follow other related articles on the PHP Chinese website!