Fault symptom:
Logical_test indicates any value or expression in which the calculation result is TRUE or FALSE. For example, A10 = 100 is a logical expression. If the value in cell A10 is 100, the expression is TRUE. Otherwise, the expression is FALSE. This parameter can use any comparison operator.
Solution:
Logical_test indicates any value or expression in which the calculation result is TRUE or FALSE. For example, A10 = 100 is a logical expression. If the value in cell A10 is 100, the expression is TRUE. Otherwise, the expression is FALSE. This parameter can use any comparison operator.
Value returned when Value_if_true logical_test is TRUE. For example, IF this parameter is set to "within budget" and the value of logical_test is TRUE, the IF function displays the "within budget" text ". If logical_test is TRUE and value_if_true is null, this parameter returns 0 (0 ). To display TRUE, use the logical value TRUE for this parameter. Value_if_true can also be another formula.
Value returned when Value_if_false is set to FALSE. For example, IF this parameter is a text string "out of budget" and the value of logical_test is FALSE, the IF function displays the text "out of budget ". If logical_test is FALSE and Value_if_false is ignored (that is, value_if_true without a comma), the logical value FALSE is returned. If the value of logical_test is FALSE and the value of Value_if_false is null (that is, value_if_true is followed by a comma and parentheses), 0 (zero) is returned for this parameter ). Value_if_false can also be another formula.
IF function operation method
Open the required software Excel, directly in the required cell data = if (conditions, results that meet the conditions, results that do not meet the conditions), of course, the entire if statement supports nesting, for example, it may be = if (condition 1, result that meets the condition, if (condition 2, result that meets the condition, result that does not meet the condition ))!