The following Product table calculated column definitions use the IF function in different ways to classify each product based on its list price. To execute the branch expressions regardless of the condition expression, use IF.EAGER instead. To learn more about implicit data type conversion, see Data types. In the latter case, the IF function will implicitly convert data types to accommodate both values.įor example, the formula IF(, TRUE(), 0) returns TRUE or 0, but the formula IF(, 1.0, 0) returns only decimal values even though value_if_false is of the whole number data type. The IF function can return a variant data type if value_if_true and value_if_false are of different data types, but the function attempts to return a single data type if both value_if_true and value_if_false are of numeric data types. If omitted, BLANK is returned.Įither value_if_true, value_if_false, or BLANK. (Optional) The value that's returned if the logical test is FALSE. The value that's returned if the logical test is TRUE. ![]() ![]() ![]() Syntax IF(, )Īny value or expression that can be evaluated to TRUE or FALSE. Checks a condition, and returns one value when it's TRUE, otherwise it returns a second value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |