![]() ![]() For example, in most other functions where a number is required, the text value "19" is converted to the number 19. Any numeric values that are enclosed in double quotation marks are treated as text. The value arguments of the IS functions are not converted. (Note that this function returns TRUE if the value refers to a blank cell.) Value refers to any item that is not text. Value refers to the #N/A (value not available) error value. ![]() Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). Value refers to any error value except #N/A. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these. The IS function syntax has the following argument: If so, the IF function returns the message "An error occurred." If no error exists, the IF function performs the calculation A1*2. This formula checks to see if an error condition exists in A1. = IF( ISERROR(A1), "An error occurred.", A1 * 2) For example, you can use the ISERROR function in conjunction with the IF function to perform a different action if an error occurs: You can use an IS function to get information about a value before performing a calculation or other action with it. For example, the ISBLANK function returns the logical value TRUE if the value argument is a reference to an empty cell otherwise it returns FALSE. Each of these functions, referred to collectively as the IS functions, checks the specified value and returns TRUE or FALSE depending on the outcome. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |