With this formula, you can string together multiple IF statements. IF(logical_expression, value_if_true, IF(logical_expression2, value_if_true2, IF(logical_expression3, value_if_true3, value_if_false))) This will allow you to evaluate multiple expressions and return a different value depending on the result. You can combine more than one IF statement together to create a nested IF statement. If this expression evaluates to FALSE my third parameter is set to return “No”. If this expression evaluates to TRUE my second parameter is set to return “Yes”. ![]() You can see in the above example I am referencing the cell (A2) to determine if A2 is greater than 5. Here is a basic example of the way this function can be used. You can also place a value to return inside quotation marks similar to the value_if_true parameter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |