- 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 .
Description
• 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 function ISNUMBER returns FALSE .
• IS class functions are very useful when checking calculation results with formulas. When used in conjunction with the IF function, it provides a way to
Detect error value.
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/ISREF-han-shu-pan-duan-zhi-shi-fou-wei-dan-yuan-ge-yin-yong.html
支付宝扫一扫 
评论列表（196条）
测试