How to use the nesting function of the IF function in excel function

Method steps.

Open the excel document, click "Insert" in the menu bar, select "Function", and click.

Enter the data according to the requirements of the question, the nesting method is: in the third blank, that is, the "otherwise" column, after re-entering the "if()" input, you will find that there is a line of red words at the end of the "invalid", then you need to look at the function expression under the menu bar, you will see a half parentheses)", this half bracket is deleted, then he will re-pop up a blank if function dialog box, as shown in the figure, look at the menu bar again.

Continue to follow the question, remember to nest the if function, just find step 5 to do it.

Finally, let's take a look at the function dialog in the diagram, is there a problem with the third item? What's the problem, think about whether the 5th step is deleted a)"=

So at the end to make up, of course, this question, I deleted a total of two) "Finally, you have to make up two, as shown in the figure, you can also look at the function, if you are familiar with the function, you can directly enter the formula in the cell.

If function usage: Determine whether a condition is satisfied: if it is satisfied, it returns a value, and if it is not, it returns another value.

If function syntax format: =if(logical test, value if true, value if false).

In layman's terms, if is a conditional judgment function: =if(test condition, result 1, result 2), that is, if the "test condition" is met, "result 1" is displayed, and if the "test condition" is not met, "result 2" is displayed.

When writing a nested multi-condition formula for an if function, pay attention to the following:

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

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

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

4. Enter the left bracket and the right bracket at the same time when entering the parentheses, so that there will be no problems with the number and level of brackets, and it is also very helpful to develop good habits for learning other functions in the future.

The mixed nesting of if and and or is: if(and(condition 1, condition 2)), if(or(condition 1, condition 2)).

The structure of a single if function: if (condition, the result is true to return the value, and the result is false to return the value). The addition of the logical operator "AND" and the source of stupidity "or" is to add a layer of AND or or to the original conditional judgment statement, and the structure is:

if(and(Condition 1, Condition 2), the result is true to return the value, and the result is false to return the value).

if(or(Condition 1, Condition 2), the result is true to return the value, and the result is false to return the value).

Examples: 2 items are excellent with a score of 90 and above, and 1 item with a score of 90 or above is good, otherwise average.

The formula is used: if(and(b4>=90,c4>=90),"Excellent ,if(or(b4>=90,c4>=90),"Good, first-class family-like ))).

Precautions. Parameters must be able to be evaluated as logical values, such as true or false, or for an array containing logical values ( Used to establish a single formula that can produce multiple results or perform operations on a set of parameters arranged in rows and columns. Array regions share a formula; An array constant is a set of constants used as parameters) or references.

If the array or reference argument contains text or blank cells, these values are ignored.

If the specified region does not contain a logical value, the function OR returns the wrong value value!.

Here's how to use the if nested function:

The conditional judgment of the inner if function is not judged separately, but is judged after the outer judgment, and there is an inheritance relationship. For example, if you want to pass through several doors in a row, you can only pass through the second door if you pass through the first door first.

If you don't even meet the conditions for the passage of the first door, then sorry, we will not see if you meet the conditions for the passage of the second door, and you will be excluded directly. Conversely, if you have already passed Gate 2, then you must have passed Gate 1 as well. To put it simply, there are multiple conditions that need to be met.

excel**

Microsoft Office Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems.

The software's intuitive interface, excellent calculation capabilities, and charting tools, coupled with successful marketing, have made Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.