HOW TO WRITE THE IF FUNCTION FORMULA IN EXCEL?

Material Tools: Excel2010

1. Open excel2010**, take the following data as an example, if the student's score is above the average score, it is qualified, if it is below the average score, it is unqualified;

2. First, select the cell you want to output the result, then select "Formula" in the upper menu bar, then select "Insert Function", and select "if" function;

3. The first is to set the test conditions, select the score of the first person, and then enter "<" and then enter the average score of 78;

4. Then set the second column, enter "unqualified" in the second column, enter "qualified" in the third column, and then click OK;

5. The results of the calculation will come out directly, and the results of the following people can be calculated immediately as long as they pull down the small dot in the lower right corner of the cell.

d2=if(and(b2="Q&A",c2>=80),100,if(and(b2="Article",c2>=24),100,0))

Drop-down formula. Try it.

D2 cell input formula:

if(or(and(b2="Q&A",c2>=80),and(b2="Article",c2>=24)),100,0)

Just copy and pull down.

The formula is written as: b1=if(a1,"Senior Engineer",200,if("Engineer",100,if("Technician",50,0))) The steps to write a formula with the function if in Excel** are as follows: 1. Click Insert and select the function.

The formula is written as: b1=if(a1,"Senior Engineer",200,if("Engineer",100,if("Technician",50,0)))

The steps to write a formula with the function if in Excel** are as follows:

1. Click Insert and select the function.

2. Select the if function in the common functions.

3. The first one represents the condition, and the last two are the result of judging the condition.

4. Enter the conditions and click OK.

5. Final results.

The understanding of the if function sheet in excel is to make logical judgments.

if (judgment condition, the value returned when the condition is met, and the value returned when the condition is not met) For example:

This means that if e3<60, it returns "poor", if e3<70, it returns "pass", if e3<80, it returns "good", and if e3 80, it returns "excellent".

The following introduces how to use the if formula in Excel, I hope this guide can help you.

Well, we can use the if formula to achieve this.

Enter the formula here in cell b43: =if(a43<300,a43,""

Formula explanation: if is a conditional function, the whole formula means that when the A43 cell is less than 300, the value of the A43 cell will be displayed, otherwise, it will be displayed as empty.

Double-click the mouse to auto-fill the formula downward, then the following cells will automatically display the corresponding results. Then, we use the if formula to extract the values less than 300.

The formula is written as: b1=if(a1,"Senior Engineer",200,if("Engineer",100,if("Technician",50,0)))

The steps to write a formula with the function if in Excel** are as follows:

1. Click Insert and select the function.

2. Select the if function in the common functions.

3. The first one represents the condition, and the last two are the result of judging the condition.

4. Enter the conditions and click OK.

5. Final results.

The usage of the if function in excel is if (the result is true or false condition, when the condition is true, the value is returned, and when the condition is false, the value is returned), the usage is relatively simple, many times, the if function is often nested with a layer or even multiple layers of if function, in fact, I understand the use of the if function, layer by layer, and it is easy to read the formula.

Operating system: win10; Software version: Office2007if function nesting usage examples are illustrated below:

1.According to the data of column A, column B shows the following content: greater than 80, excellent; More than 60 and less than 80, general; Less than 60, poor:

2.The input formula is as follows:

Formula explanation: two layers of nested if functions, the first layer of if functions, the judgment condition is the value of column a" 80;If the condition result is true, that is, if the value of column A is greater than 80, the text "excellent" is returned. If the condition result is false, that is, if the value of column A is less than 80, the secondary if function is performed to determine whether it is greater than 60, and the result is true, that is, the value of column A is less than 80 and greater than 60, and "normal" is returned. If the result is false, if the value of column A is less than 60, "Poor" is returned.

3.Pull down the fill, and get the result as follows:

1. The syntactic structure of the if function:

if: Performs true or false value judgment and returns different results based on the true or false values of the logic test. Grammatical structure: if (condition, result 1, result 2).

Second, the operation method:

Method 1: 1. Open the required software excel, enter the required **, and then find the first line of the filled level information, and then, find the "fx" in the toolbar or click the menu "insert" "fx function" in the paste function window that appears, select "all" move the scroll bar and select "if".

2. At this time, the if function window appears, enter the first condition in the first text box, enter the first condition result in the second text box, and enter all the subsequent conditions and corresponding results in the third text box.

For example, the formula: if(b2>89,"a",if(b2>79,"b",if(b2>69,"c",if(b2>59,"d","f"First condition B2>89, first condition result"a", the third text box inputs: if(b2>79,"b",if(b2>69,"c",if(b2>59,"d","f"

Method 2: Enter the following formula in the formula field.

The if function is a judgment statement.

Enter where you need to display the cell.

if(1=1,1,0)

The meaning of this sentence is that if 1 is equal to 1, 1 will be displayed, otherwise 0 can also be written like this.

if(a1=b1,c1,d1)

The name of the reference cell.

The understanding of the if function sheet in excel is to make logical judgments.

if (judgment condition, the value returned when the condition is met, and the value returned when the condition is not met) For example:

This means that if e3<60, it returns "poor", if e3<70, it returns "pass", if e3<80, it returns "good", and if e3 80, it returns "excellent".

Type =if( and then put the cursor over if and press f1 to get a specific description of if.

if(condition, result, [otherwise]).

if(condition, result, if(condition, result, [otherwise])) is optional.

For example: if(a1>1,a1-1).

The syntax of the if function is:

if(a2>20,"Done","Not finished"The formula in b2 means that the "amount of completion" in a2 is not greater than 20, that is, "the condition is false", so it returns "incomplete"; In the formula of B4, because the "Completion" in A4 is greater than 20, that is, "the condition is true", it returns "Complete".