What to do if the excel formula if function has more than three conditions

What to do if the excel formula if function has more than three conditionsHow to use the three conditions of the excel**if function? if is a logical function in excel, which performs true and false value judgment, and returns different results according to the true and false values calculated by logic, with 3 parameters:

Conditions, true results, and false results, let's introduce the use of the if function in detail.

Tool raw material use version: excel2010 operating equipment: laptop.

Method: Read step by step.

Here for example, use if to judge whether the score is passed, if it is less than or equal to 14s, it means pass, we first open the excel sheet, click the cell, click the menu bar formula - insert function;

A window pops up, we enter if in the input box, click to find the if function;

Next, we need to set the 3 parameter conditions of if, first set the first parameter logcal test, here is to set the judgment condition, enter b2<=14;

The second parameter is value if true, which represents the result obtained when the judgment condition is true, for example, here it passes within 14s with a speed, and if the value is true, it will return to pass;

The third parameter is value if false, which represents the result obtained when the judgment condition is false, if the value is false, it will return that it has not passed, click OK;

After clicking, we can judge the result, click on the lower right corner of the cell to pull down;

Drag down with the mouse to return all judgment results.

Summary: 1. Select the cell and click the formula - insert function;

3. Set 3 condition parameters, logcal test, and set judgment conditions;

4. value if true input the result judged to be true;

5. value if fasle input the result judged to be false;

6. Click OK to get the result.

Precautions. You can enter a function directly when inserting it, or you can insert a formula through the menu.

1. If the three conditions correspond to the three outcomes, then if(condition 1, result 1, if(condition 2, result 2, if(condition 3, result 3, other cases))).

2. If all three conditions need to be true at the same time, then if(and(condition 1, condition 2, condition 3), result, other cases).

logic and and().

logical or or().

The logic is not not().

In addition, the logical value can be converted to a numeric value, 0 is false, and non-zero is true in the operation with the same result of the logical value

and(): can be simplified to multiply each logic, that is, arbitrary zeros are multiplied by zero. That is, all the phases are not zero, and they are not zero.

or(): can be reduced to a logical addition, i.e., any non-zero (the logical return value is 1, excluding arithmetic is a negative value), i.e. as long as it contains non-zero.

Condition 1 * Condition 2 * Condition 3 = and (Condition 1, Condition 2, Condition 3) Condition 1 + Condition 2 + Condition 3 = or (Condition 1, Condition 2, Condition 3) Not (Condition), i.e. all cases where this condition is the opposite. not(false)=true

false=0

true=1

How to write the three conditions of the if formula, the operation method is as follows.

1. First of all, in the main page that opens, select the cells that need to be calculated.

2. Enter the function formula in the cell: =if(b2>=90,"Excellent",if(b2>=80,"Good",if(b2>=60,"Pass"There are three conditions.

3. After the input is completed, click the [Tick] icon.

4. Then double-click the small green square with the left mouse button. If formula, the three conditions are completed.

The parallel logic function is and. The logic of the if function juxtaposition condition is as follows:

if(and(Condition 1, Condition 2), Outcome 1, Outcome 2).

If you meet both the AND and meet one of the conditions, you can use OR.

if(or(Condition 1, Condition 2), Outcome 1, Outcome 2).

Function formula: =if(d4<80,"Unqualified","Eligible")。

According to the parameter definition of the if function, the first condition is the judgment condition, and when the first parameter is true, the result shows the value of the second parameter; When the first parameter condition is not true, the value of the third parameter is executed.

FunctionalThe if function is a conditional judgment function: if the result of the specified condition is true, the if function will return a certain value; If the condition evaluates to false, another value is returned.

For example, 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.

In Excel, a set of data information is input into column A**, which is used to use the if function to input three conditions for data information operations.

Enter the if formula in b2**: =if(a2<60,"1",if(a2<100,"2",if(a2<200,"3",) means that if the data information in A2** is less than 60, the number 1 will be displayed, if the data information is less than 100, the number 2 will be displayed, and so on.

Learn the if function: =if(a,b,c), where a represents the logic that needs to be judged, b represents the value returned if the judgment result of a is ture, and c represents the value returned if the judgment result of a is false. Literally:

If (the content is true, then do the action here, otherwise do something else).

Parameter. Logical test represents any value or expression that evaluates to true or false. For example, a10=100 is a logical expression that is true if the value in cell a10 is equal to 100, and false otherwise.

This parameter can use any of the comparison operators (= (equal to), > greater than, > greater than or equal to), "less than or equal to", etc.

For the above content, please refer to: Encyclopedia-if function.

1. The composition of the if function = if (if, then, otherwise), the if function is composed of three parts, the first is to judge, if it is established, then it is true, and if it is not established, it is otherwise.

2. Let's open the excel** in the computer to open some data.

3. One thing that needs to be paid special attention is that in excel, =0 can be considered false.

<>5. Use the if function, if =0, then the output is failing, if it is not equal to 0, the output is blank.

The three conditions input method of IF in Excel is as follows:

Enter a set of data information in column A ** in Excel, which is used to use the if function to input three conditions for data information operations, and input the if formula =if(A2<60,) in B2**"1",if(a2<100,"2",if(a2<200,"3",if(a2<280,"4",) means that if the data information in a2** is less than 60, the number 1 will be displayed.

If the data information is lower than 100, the number 2 will be displayed, and so on, press the enter key, it can be converted into a formula calculation result, the display result is the number 1, which means that the data information in A2** is lower than 60, drag the B2 column formula to fill it down, and you can calculate the interval where the input data information in column A is located in large quantities.

What is the if function in Excel?

The if function is a logical function in excel, which is widely used in our practical work, and the use of the if function can help us to complete some conditional judgments. The concept of the if function is to determine whether a certain condition is met, if it is satisfied, it returns a value, and if it does not, it returns another value.

How to use: Open Excel, open your data file, click "Insert" on the toolbar in the cell where you want to output data - "Function" - Logic "-if", and then click OK.

If function syntax: if (logical test, value if true, value if false). The first conditional logical test represents any value or expression that evaluates to true or false.

The second condition, value if true, represents the value returned when the logical test is true. The third condition, value if false, represents the value returned when logical test is false.

Logical test represents any value or expression that evaluates to true or false. For example, a10=100 is a logical expression that is true if the value in cell a10 is equal to 100, and false otherwise. This parameter can use any of the comparison operators (= (equal to), > greater than, > greater than or equal to), "less than or equal to", etc.

value if true indicates the value returned when the logical test is true. For example, if this parameter is a text string "Budgeted" and the Logical Test parameter value is true, the if function will display the text "Budgeted". If logical test is true and value if true is empty, this parameter returns 0.

If you want to display true, use a logical value for this parameter, which can also be a different formula.

value if false indicates the value returned when logical test is false. For example, if this parameter is a text string "Over budget" and the logical test parameter value is false, the if function will display the text "Over budget". If the logical test is false and the value if false is ignored (i.e., there is no comma after the value if true), 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), this parameter returns 0 (zero). value if false can also be some other formula.

The if function generally refers to the conditional function in software such as programming or excel, which judges its "true" and "false" according to the specified conditions, and returns the corresponding content according to the true and false values calculated by logic. You can use the function if to perform condition detection on values and formulas.

If in Excel when multiple conditions are combined, use the if function to combine"+"sign and "*" sign can meet the judgment requirements. The specific steps are as follows:

1. First open Excel** and enter the data you need to judge in the worksheet.

2. Then enter the formula in cell d1: "=if((a1=2)+(b1=2),"Yes","Nope")”

3. After pressing the Ctrl+Shift+Enter key, the D1 cell will output the result judged by the judgment formula composed of the if function and the "+" sign, and the condition 1 and condition 2 of the if function can meet one of them.

4. Then enter the formula in cell d1: "=if((a1=2)*(b1=2),"Yes","Nope")”

5. After pressing the Ctrl+Shift+Enter key, cell D1 will output the judgment result of the judgment formula composed of the if function and the "*" sign, and the conditions 1 and 2 of the if function must be satisfied.