Excel from the rookie to become a master of the IS function

  The third measure: testing the waters (IS function)

 This trick is used on the current value of a cell to determine the type, in order to know its type, and then take next course of action, it is called testing the waters.

 IS function, a total of nine worksheet functions. Broad class of functions for the IS, you can test the type of numerical values based on parameter returns TRUE or FALSE. For example, if the value is a reference to the blank cells, the function returns a logical value ISBLANK TRUE, otherwise returns FALSE.

 Syntax

 ISBLANK (value)

 ISERR (value)

 ISERROR (value)

 ISLOGICAL (value)

 ISNA (value)

 ISNONTEXT (value)

 ISNUMBER (value)

 ISREF (value)

 ISTEXT (value)

 Value for the required test values. Are as follows: blank (empty cell), error values, logical values, text, numbers, reference values, or for any of the above parameters the name of the reference.

 Application examples:

 Explained

 The formula "= ISBLANK (A1)", said a cell of A1 to judge whether it is empty. The case is empty, it returns "True" value, if not empty, it returns "False) value.

 The above example, the figure, B1 and B2 in the cell A1 and A2 respectively function the cells to determine whether the blank. The results show a true and a false