IF is a conditional judgment function: =IF (test condition, result 1, result 2), that is, if the "test condition" is met, the "result 1" will be displayed, and if the "test condition" is not met, the "result 2" will be displayed.
Logical_test represents any value or expression that evaluates to TRUE or FALSE.
For example, A 10= 100 is a logical expression. What if cells? The value in A 10 is equal to 100, and the expression is? Really, or what? Error. This parameter can use any comparison operator (flag or symbol) to specify the type of calculation performed in the expression. There are mathematics, comparison, logic and reference operators. )。
The value returned when Value_if_TRUE logical_test is TRUE.
For example, IF this parameter is the text string "within budget" and the logical_test parameter value is TRUE, the if function will display the text "within budget". If logical_test is TRUE and value_if_true is empty, the parameter returns 0 (zero). If you want to display TRUE, use the logical value TRUE for this parameter. Value_if_true can also be other formulas.