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

Post a Comment

jeetexceltips@gmail.com

Popular posts from this blog

50 Excel VBA Oral Interview Questions

Ques 01. What is the difference between ByVal and ByRef and which is default ? Solution: ByRef: If you pass an argument by reference when calling a procedure the procedure access to the actual variable in memory. As a result the variable's value can be changed by the procedure. ByVal: If you pass an argument by value when calling a procedure the variable's value can be changed with in the procedure only outside the actual value of the variable is retained. ByRef is default: Passing by reference is the default in VBA. If you do not explicitly specify to pass an argument by value VBA will pass it by reference. Ques 02. What is the meaning of Option Explicit and Option Base? Solution: Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0. Option Base - When an array is declared by d...
Read more