How to set up if function in excel table

We often use functions when using excel to process data. Let's take a look at how to use the IF function in excel.
1. Use excel to open our data table, then select a cell and enter the IF function in the cell.
2. After entering the function, we enter the first parameter of the function and pre ss the comma key,
3. Enter the second parameter after the comma key, and pre ss the comma key.
4. Enter the third parameter after the comma key.
5 , enter the third number and pre ss the Enter key to get the calculated result,

The if function is often used in Excel to determine whether the data meets the conditions. How to use the if function specifically? The following is the editor's guide Here is a tutorial on using the if function in excel tables. I hope it will inspire you after reading it!

Tutorial on using the if function in excel tables (1)

Step 1: Find the logic we want to use Judge the table and find the row or column where the judgment result is located.

Step 2: Enter the formula: Left-click the bidding at FX above the table, and a dialog box will pop up.

Step 3: In the or selection category, select "Logic" and then select "IF" below.

Step 4: Select the "IF" function. A dialog box pops up

60" ", if it is greater than or equal to, we will enter ">=". At this point, it must be noted that the condition must be "a certain cell - condition - condition value" to be a complete logical relationship.

Value_if_true repre sents the value returned if the above conditions are true. For example, if we want to return "qualified", we enter "qualified" in the subsequent box.

Value_if_falsr indicates the town to be returned if the above conditions are not met. For example, if you want to return "unqualified", enter "unqualified"

Step 6: Note that we have entered the above returned When specifying conditions, you don’t need to enter double quotes. We only enter the returned conditions, and the system automatically adds double quotes. Click OK when finished and you're done. Drop-down menu, the formula settings for the entire table are completed.

Step 7: This is what the rendering looks like

Tutorial on using the if function in excel tables (2)

Step 1: Open Excel, open your data document, and where you want to output the data Cell click "Insert" - "Function" - "Logic" - "IF" on the toolbar, and then click OK.

Step 2: After clicking OK, a box will pop up. The first one repre sents the condition, and the next two are the results of judging the condition. Click on the place marked by the editor and select the data. Generally, we do not need to select all the data, we only need to select one of them.

Step 3: The editor will choose A2. We use IF to judge whether the math score is a passing grade or not. If the condition is <60 points, it means that it is not true and it will show a failure. Otherwise, the rest will be passing marks.

Step 4: After clicking OK, we can see the results of the judgment. Place the mouse behind the first result. When the mouse turns into [+], we can double-click it to get all The result was.

Step 5: However, you will ask the editor, isn’t the score classified as passing, good or excellent? How should I judge? In fact, it is very simple, just use IF continuously. The terminology is called "IF function nesting". For example, I want 60-70 to show passing, 70-80 to show good, and 80 or above to show excellent

Step 6: We then set 60-70 to show passing, and then do the same in the third line, Click IF again to nest.

Step 7: In the same way, set good and excellent. If you want to continue dividing later, you can also continue to nest, so don’t write excellent in the third line.

Step 8: Similarly, we put the mouse on the [+] in the lower right corner of the first result and double-click to display all the results.