How to use two conditions in excelif function

The excelif function uses two conditions: first enter "=if" in the blank cell to the right of the first row of data that needs to be judged, double-click if to call out the function; then double-click and to call out the function setting two condition; then continue the if function, set the content to be displayed when the judgment is true and the content to be displayed when the judgment is false; finally press the Enter key to calculate the result.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The excelif function uses two conditions:

1. Open the Excel table and take the judgment score as an example

Both Chinese and mathematics are greater than 80 The ones that are excellent are considered excellent, the rest are qualified

2. Enter "=if" in the blank cell to the right of the first row of results that need to be judged, and double-click if to call up the function

3. Enter and in the if function, double-click and to call out the function

Used to enter multiple conditions

4. Set two conditions, separated by commas

That is, the condition is "AND(B2>80,C2>80)"

5. After setting the two conditions, continue the if function and set the content displayed when the judgment is true to "excellent", and the content displayed when the judgment is false to "qualified"

That is The entire function is "=IF(AND(B2>80,C2>80),"Excellent","Qualified")"

##6. Press the Enter key. Calculate the result

7. Use the following to automatically fill in the remaining columns

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