!value!!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: a cell; a formula; or a name referring to a cell, formula, or value!
value!Checks whether a value is a number, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
value!Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is ...
value!Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...