![]() Unlike numbers and strings, comparison operators, when used with dates, have a slightly different meaning. You can then use the following IF function for this scenario: =IF(A2=10,"yes","no")Ĭomparing Dates in Excel (Using Operators) value_if_false is the value that you want the IF function to return if the logical_test evaluates to FALSEįor example, say you want to write a statement that will return the value “ yes” if the value in cell reference A2 is equal to 10, and “ no” if it’s anything but 10.value_if_true is the value that you want the IF function to return if the logical_test evaluates to TRUE. ![]() The result of this parameter is either TRUE or FALSE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |