Figure 6

IS functions is the value used to test or invoke the type of worksheet function in Excel in a total of nine such function. On a number of functions including:

(1) ISBLANK If the value is empty, then return TRUE

(2) ISERR In addition, if a value of # N / A error value of any returns TRUE

(3) ISERROR error if the value of any value, then return TRUE

(4) ISLOGICAL logic value if the value is returned TRUE

(5) ISNA If the value of # N / A error value, then return TRUE

(6) ISNONTEXT If the value is not text, then return TRUE

(7) ISNUMBER If the value of the number, then return TRUE

(8) ISREF If the value is quoted, then return TRUE

(9) ISTEXT If the value of the text, then return TRUE

These functions, summarized as IS-type function, can test the type of numerical values based on the parameters to return TRUE or FALSE. For example, if a blank value for the reference cell, the logic function ISBLANK return value TRUE, otherwise return FALSE. The syntax of the form of function (value) which need to be tested Value for value. IS for different functions are as follows: blank (empty cell), error values, logical values, text, numbers, reference value or any parameters for the name of the above quote.

IS should be noted that the parameters of value functions can not be converted. For example, in the other a function of the number of majority, the text value of "19" will be converted into the number of 19. However, in the formula ISNUMBER ( "19"), the "19" is not converted by the text of the value of other types of value, function ISNUMBER return FALSE. The main functions IS the formula for the test results. When it is combined with the use of IF functions can be used to provide a way to detect errors in the formula value.

Figure 7