How do I mix the if function with and,or?

I don't know exactly what I want.,If it's like this.,You can find it in the library and know.

if(and(d1>=20,b1<30),"e",if(or(a1>10,b1>40),"c","w"))

Grammar. if(logical_test,value_if_true,value_if_false)

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 evaluates to true; Otherwise, false. Any comparison operator can be used for this parameter.

value if true is the value returned when logical test is true. For example, if this parameter is a text string "within budget" and the logical test parameter evaluates to true, the if function displays the text "within budget". If logical test is true and value if true is empty, this parameter returns 0 (zero).

To display the word true, use a logical value for this parameter, which can be a different formula.

value if false is the value returned when logical test is false. For example, if this parameter is a text string "Over budget" and the logical test parameter evaluates to false, the if function displays the text "Over budget". If the logical test is false and the value if false is omitted (i.e., the value if true is followed by no comma), the logical value false is returned.

If logical test is false and value if false is null (i.e., value if true is followed by a comma followed by a closing parenthesis), the value 0 (zero) is returned. value if false can be other formulas.

Note. Grammar.

and(logical1,logical2, .

logical1, logical2, .are 1 to 255 conditions to be detected, and they can be true or false.

Grammar. or(logical1,logical2,..

logical1,logical2,..are 1 to 255 conditions that need to be tested, and the test result can be true or false. Note.

if(and(condition 1, condition 2)), if(or(condition 1, condition 2)).

A single if function.

The structure of the : if(condition, the result is true to return the value.

The result is false). Add logical operators.

and" and "or", that is, a layer of and or or is added to the conditional judgment statement of the original Yinhuai, 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, average))).

Place the mouse in the lower right corner of cell d4, it will change to a black cross, and double-click it to automatically fill in the formula, the result is as follows:

Illustrate. In Excel2003, the function if can be nested in seven layers, and in Excel2007, the limb friend can be nested in 64 layers, and complex detection conditions can be constructed with value if false and value if true parameters. After the parameters value if true and value if false are evaluated, the if function returns the returned value after the execution of the corresponding statement.

If the arguments of the function if contain an array (used to build a single formula that can produce multiple results with a pair of eyes or can perform operations on a set of parameters arranged in rows and columns. Array regions share a formula; Array constants.

is a set of constants used as arguments), then every element in the array will be evaluated when the if statement is executed.

excel**。

There are also other functions that allow you to analyze the data based on conditions. For example, if you want to count a text string in a range of cells.

or the number of occurrences of a number, you can use the countif worksheet function. If you want to sum based on a text string or number in a range of cells, you can use the sumif worksheet function. Learn about calculating values based on conditions.

Usage of the combination of the and if functions:

1. Select cell D2 and enter "=if(and(b2>=25000,c2=""Excellent staff"，"Judging by confirmation, if you meet the requirements, you will be shown as an excellent employee.

2. The formula means that if the value in the B2 cell is greater than or equal to 25000, and there is no data in the C2 cell, it will be judged and displayed as an excellent employee, and if any of the two conditions do not meet, it will not be displayed ("Wheel opening"indicates a blank).

3. Select cell D2, copy and fill it in the D3:D5 area, and automatically judge the condition of the employee.

Grammatical analysis. a10=100 is a logical expression.

If the value in cell A10 is equal to 100, the table is true, otherwise it is false. This parameter can use any comparison operator (a flag or symbol that specifies the type of computation performed within the expression. There are mathematical, comparative, logical, and referential operators, among others.

value if true The value returned when logical test is true.

For example, if this parameter is a text string.

Within Budget" and the value of the Logical Test parameter is true, the if function will display the text "Within Budget". If logical test is true and value if true is empty, this parameter returns 0 (zero). If you want to display true, use a logical value for this parameter, which can also be a different formula.

In the if function, and represents the intersection relationship, that is, all the listed conditions must meet the sail year in order to return the value that satisfies the and condition, and or represents the union relationship, that is, the relationship of "or", and the listed conditions only need to meet one of them. In Excel, a function is actually a pre-defined specific calculation formula. Calculations are performed on one or more parameters according to this specific formula, and one or more results are obtained, which are called function values.

Using these functions not only accomplishes many complex calculations, but also simplifies how complicated formulas can be.

In order to meet the requirements of various data processing booths, excel provides a large number of functions for users to use, functions are pre-programmed formulas for numerical calculation and data processing by the system, and the use of functions can simplify or shorten the formulas in the worksheet, making data processing simple and convenient. Excel 2003 provides a wealth of functions, such as financial functions, date and time functions, numerical and trigonometric functions, statistical functions, search and reference functions, database functions, text functions, logic functions, information functions, etc.

The structure of a single shed if function is clear, i.e. if(condition, the result is true to return a value.

The result is false return value), for example: use the if function to determine whether ** is reasonable: when ** is 250 yuan, it is unreasonable, otherwise it is reasonable to enter =if(a2>250,,) in cell b2"Unreasonable","Reasonable"), where,"a2>250"When the condition is satisfied, it returns "unreasonable."", and when the condition is not met, it is returned"Reasonable

The final execution effect is as follows:

If you add a logical operator.

and"with"or", that is, a layer of and or or

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).

For example, in the case of the above, let's change the judgment rule: when ** is between 200 and 300, it is reasonable, otherwise it is unreasonable.

Enter =if(and(a2>=200,a2<=300),"Reasonable","Unreasonable"where "and(a2>=200,a2<=300)."That is, the condition of the logical operator is added, and when both are satisfied, it returns "reasonable", and the usage of or is the same.

Nested functions are more structurally complex, but their essence remains the same. It is structurally if(conditional, the result is true to return the value, if(...)

The essence is that when the condition is judged to be false, a fixed value is no longer returned, but the next if function is executed.

For example, if the report card is out, the teacher needs excel to automatically evaluate the corresponding score, where a score of less than 60 is "failing", and 60 and 80 is "passing".", 80 to 90 points "good.""A score of 90 or more is considered excellent. In this example, there are multiple layers of nested condition judgment involved.

Enter =if(and(a2>=60,a2<80),"Eligible",if(and(a2>=80,a2<90),"Good",if(a2>=90,"Excellent",if(a2<60,"Fail","Note: There are several layers of nesting, and the number of parentheses at the end of the chain is the number of nests, which is equal to "if.""The number of occurrences.