:ISERR and IF remove wrong characters in one step-Table skills免费ppt模版下载-道格办公

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)

< /span>•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 .

• Functions of the IS class are useful for 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/ISERR-yu-IF-yi-bu-qu-chu-cuo-wu-zi-fu.html