From rookie to become a master of Excel If function

 The second measure: it both ways (If the function)

 This trick is used to perform a condition to judge the true and false values, calculated according to the logical truth value, return different results. If the result is true, it returns a true, if false, it returns another value, can be described both ways.

 Syntax

 IF (logical_test, value_if_true, value_if_false)

 Logical_test that evaluates to TRUE or FALSE any value or expression. For example, A1> = 60 is a logical expression, if the value in cell A1 is greater than or equal to 60, expression is the TRUE, otherwise FALSE. This argument can use any comparison operator.

 Value_if_true logical_test is TRUE, the returned value. For example, if the parameter is the text string "budget"and logical_test parameter is TRUE, then the IF function displays the text "budget. " If TRUE and value_if_true logical_test is empty, this argument returns 0 (zero). If you want to show TRUE, please use the logical value-based argument TRUE. Value_if_true can be another formula.

 Value_if_false logical_test is FALSE, the returned value. For example, if the parameter is the text string "within budget"and logical_test parameter is FALSE, then the IF function displays the text "within budget. " Logical_test is FALSE, and if ignored Value_if_false (ie there is no comma after value_if_true), will return the logical value FALSE. If FALSE and Value_if_false logical_test is empty (ie, after value_if_true comma, and followed by closing parenthesis), this argument returns 0 (zero). Value_if_false can be another formula.

 Help

 Up to seven nested IF functions with value_if_false and value_if_true parameters can construct complex test conditions.

 Value_if_true and value_if_false in the calculation of parameters, the IF function returns the appropriate return value after statement execution