INFORMATION FUNCTIONS

4CELL : Returns information about the formatting, location, or contents of a cell 4ERROR.TYPE : Returns a number corresponding to an error type
4INFO : Returns information about the current operating environment
4ISBLANK : Returns TRUE if the value is blank
4ISERR : Returns TRUE if the value is any error value except #N/A
4ISERROR : Returns TRUE if the value is any error value
4ISEVEN : Returns TRUE if the number is even
4ISLOGICAL : Returns TRUE if the value is a logical value
4ISNA : Returns TRUE if the value is the #N/A error value
4ISNONTEXT : Returns TRUE if the value is not text
4ISNUMBER : Returns TRUE if the value is a number
4ISODD : Returns TRUE if the number is odd
4ISREF : Returns TRUE if the value is a reference
4ISTEXT : Returns TRUE if the value is text
4N : Returns a value converted to a number
4NA : Returns the error value #N/A
4TYPE :
Returns a number indicating the data type of a value

No hay comentarios: