Excel Information Functions List


Excel Information Functions List

Error Information Functions
ISERRORTests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE
ISERRTests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returnsFALSE
ISNATests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returnsTRUE; Otherwise returns FALSE
ERROR.TYPETests a supplied value and returns an integer relating to the supplied value's error type
Numerical Information Functions
ISNUMBERTests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE.
ISEVENTests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE.
ISODDTests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE.
NConverts a non-number value to a number, a date to a serial number, the logical value TRUEto 1 and all other values to 0
Other Data Type Functions
ISBLANKTests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE
ISLOGICALTests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE
ISTEXTTests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE
ISNONTEXTTests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE
ISREFTests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE
TYPEReturns information about the data type of a supplied value
General Information Functions
CELLReturns information about the contents, formatting or location of a given cell
INFOReturns information about the the current operating environment
Function Returning a Constant Value
NAReturns the Excel #N/A error

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions