!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, a formula, or a name that refers to a cell, formula, or value!
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; ...
value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...