What is the meaning of IF in Excel?
IF is an Excel form of a logical function, (to determine whether to meet a condition, if it meets the return of a value, if it does not meet the return of another value). In our daily work IF function is very widely used, the use of IF function can easily assist us to complete some of the conditions of judgment. Here we look at the use of excel if function.
1, IF function syntax to be used in excel’s cell form, the form above the blank space to enter = IF (conditions, conditions are established when the return value, conditions are not established when the return value). Basic usage
(1) in our form, click on cell C2, and then enter the formula [= IF (B2 = “male”, “men”, “women”)]. (2) Click on our Enter key Enter (3) in our excel table will appear in the return value, and then put our mouse on the edge of the cell, wait until our mouse pointer into a black cross, then double-click the mouse in the black cross can be. Advanced Usage (nested) 1, IF function of the multiple conditions of judgment
(1) in the excel table, click to cell C2, enter the formula = IF (B2 = “Polytechnic”, “LG”, IF (B2 = “Arts”, “WK”, “CJ”))].
(2) Click the Enter key Enter (3) when we form the return value appears, the mouse on the edge of the cell, wait until the mouse pointer becomes a black cross, and finally double-click the black cross can be.
2, IF function of multi-interval judgment (1) Click on the figure in cell C2, enter the formula [= IF (B2 & gt; = 600, “the first batch of”, IF (B2 & gt; = 400, “the second batch of”, “fall out of the”))]. (2) Click on our Enter key [Enter] (3) the figure appears in the return value, the mouse on the edge of the cell, waiting for the mouse pointer into a black cross, double-click on the black cross can be.
Complex Usage
1, IF function of the multi-conditional side-by-side judgment (1) Click on cell C2, enter the formula [= IF (AND (A2 = “male”, B2 & gt; = 60), 1000, 0)]. (2) Click the Enter key [Enter] (3) If the return value, the mouse on the edge of the cell until the mouse pointer becomes a black cross, double-click the black cross can be.
2, mixed multiconditional side-by-side judgment
(1) in the figure C2 cell, enter the formula [= IF (OR (AND (A2 = “male”, B2 & gt; = 60), AND (A2 = “female”, B2 & gt; = 40)), 1000, 0)].
(2) Click the Enter key [Enter] (3) as shown in the figure appears to return value, put the mouse on the edge of the cell until the mouse pointer becomes a black cross, double-click the black cross can be.
The above is excel, IF function.
IF in Excel is what it means
excel if function is a judgment function.
IF function is a conditional judgment function: if the calculation of the specified condition results in TRUE, IF function will return a certain value; if the calculation of the condition results in FALSE, then return another value.
For example, IF (test condition, result 1, result 2), that is, if you meet the “test condition” is displayed “result 1”, if not meet the “test condition” is displayed “result 2”. display “result 2”.
Prototype: IF(logical_test,value_if_true,value_if_false)
Parameters:
1. Logical_test means that the result of the calculation of any value or expression is TRUE or FALSE.
2, Value_if_true indicates the value returned when logical_test is TRUE.
3, Value_if_false indicates the value returned when logical_test is FALSE.
Spreadsheet formula if what it means
IF is a conditional function, for example:
=IF (A2>=60, “pass”, “fail”)
The formula says: A2 if it meets the greater than or equal to 60, return “pass” results; if A2 does not meet the conditions, return “fail” results; if A2 does not meet the conditions, return “fail” results. to meet the conditions, the return of “failed” results.