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 |