IF function unknown system provided House theme today: unknown IF functions provided

truth value determination performed according to a logical truth value calculations, and returns the result. You can use the function IF to conditionally evaluate values ​​and formulas. Syntax



IF (logical_test, value_if_true, value_if_false)

Logical_test shows a calculation result TRUE or FALSE any value or expression.

e.g., A10 == 100 is a logical expression, if the value in cell A10 is equal to 100, that is, the expression TRUE, otherwise to FALSE. This parameter can use any comparison operator (a tag or symbol that specifies the type of calculation performed within the expression. There are math, comparison, logic, and reference operators, etc.).

Value_if_truelogical_test value returned is TRUE.

For example, if this parameter is a text string "budget" and logical_test parameter is TRUE, then the IF function displays the text "budget." If logical_test is TRUE and value_if_true is empty, this 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.

Value_if_falselogical_test value returned to FALSE.

For example, if this parameter is a text string "budget" and logical_test parameter is FALSE, the IF function displays the text "budget." If logical_test is FALSE and value_if_false is ignored (ie no comma after value_if_true), the logical value FALSE is returned. If logical_test is FALSE and value_if_false is empty (ie, there is a comma after value_if_true followed by the closing parenthesis), this parameter returns 0 (zero). VALUE_if_false can also be other formulas.