It's a bit unexpected, isn't it? Here is an example of such a formula: If the logical test evaluates to FALSE and the value_if_false parameter is omitted (there is just a closing bracket after the value_if_true argument), the IF function returns the logical value FALSE. If you don't care what happens when the specified condition is not met, you can omit the 3rd parameter in your formulas, which will result in the following. The following screenshot demonstrates the above approaches in action, and the second one seems to be more sensible: Technically, in this case the formula returns an empty string, which is invisible to the user but perceivable to other functions. In case you don't want your Excel IF statement to display any value when the condition is met, enter double quotes ("") in the second parameter, like this: =IF(B1>10, "", "Bad"). there is only a comma following logical_test), the IF function returns zero (0) when the condition is met. If the value_if_true argument is omitted (i.e. Though the last two parameters of the IF function are optional, your formula may produce unexpected results if you don't know the underlying logic beneath the hood. if the condition is not met.įor example, if you add "Bad" as the third parameter to the above formula, it will return the text " Good" if a value in cell B1 is greater than 10, otherwise, it will return " Bad":
value_if_false (optional) - the value to be returned if the logical test evaluates to FALSE, i.e.if the condition is met.įor example, the following formula will return the text "Good" if a value in cell B1 is greater than 10: =IF(B1>10, "Good") value_if_true (optional) - the value to return when the logical test evaluates to TRUE, i.e.In this argument, you can specify a text value, date, number, or any comparison operator.įor example, your logical test can be expressed as or B1="sold", B110. logical_test (required) - a value or logical expression that can be either TRUE or FALSE.IF(logical_test,, )Īs you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional.
0 kommentar(er)
