- Picture and text skills
- Case
This section describes nine worksheet functions for testing numeric or reference types.
These functions, summarized as IS class functions, can check the type of a value and return TRUE or FALSE depending on the parameter value.
For example, the function ISBLANK returns the logical value TRUE if the value is a reference to a blank cell, otherwise it returns FALSE.
Syntax ISBLANK(value) ISERR(value) ISERROR(value ) ISLOGICAL(value) ISNA(value) ISNONTEXT(value) ISNUMBER(value) ISREF(value) ISTEXT(value) •VALUE is the value that needs to be tested.
are: blank (blank cell), error value, logical value, text, number, reference value or name reference to any of the above parameters .
• The parameter value of IS class functions is not convertible. For example, in most other functions that expect numbers, the text value "19" is converted to the number 19.
However, in the formula ISNUMBER("19"), "19" is not converted from a text value to another type of value, and the ISNUMBER function returns FALSE.
• IS class functions are useful for checking calculation results with formulas. When used in conjunction with the IF function, it provides a way to find erroneous values in formulas.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ISNONTEXT-han-shu-shi-bie-fei-wen-ben-zhi-jian-bian-zhi-nan.html
评论列表(196条)
测试