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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |