- Compare worksheets
- Database analysis
- Stock to your Excel
- Password recovery
- and many more...
Excel's Information functions gives information about the data in a cell or range of cells. it includes whether the data is a number, the formatting applied to the cell, or even if the cell is empty.
Download our FREE Excel Utility
Provide many features and shortcuts to your Excel use
Type function returns the type of a value. The sy...
Cell
In Excel, the Cell function can be used to retrieve information about a cell. This can include contents, formatting, size, etc. The syntax for the Cell function is: Cell( type, range ) type is the type of information that you'd like to retrieve for the cell. type can be one of the following values: Value Explanation "address" Address of the cell. If the cell refers to a range, it is the first cell in the range. "col" Column number of the cell. "color" Returns 1 if the color is a negative value; Otherwise it returns 0. "contents" Contents of the upper-left cell. "filename" Filename of the file that contains reference. "format" Number format of the cell. See example formats below. "parentheses" Returns 1 if the cell is formatted with parentheses; Otherwise, it returns 0. "prefix" Label prefix for the cell. * Returns a single quote (') if the cell is left-aligned. * Returns a double quote (") if the cell is right-aligned. * Returns a caret (^) if the cell is center-aligned. * Returns a back slash (\) if the cell is fill-aligned. * Returns an empty text value for all others. "protect" Returns 1 if the cell is locked. Returns 0 if the cell is not locked. "row" Row number of the cell. "type" Returns "b" if the cell is empty. Returns "l" if the cell contains a text constant. Returns "v" for all others. "width" Column width of the cell, rounded to the nearest integer. For the "format" value, described above, the values returned are as follows: Returned Value for "format" Explanation "G" General "F0" 0 ",0" #,##0 "F2" 0.00 ",2" #,##0.00 "C0" $#,##0_);($#,##0) "C0-" $#,##0_);[Red]($#,##0) "C2" $#,##0.00_);($#,##0.00) "C2-" $#,##0.00_);[Red]($#,##0.00) "P0" 0% "P2" 0.00% "S2" 0.00E+00 "G" # ?/? or # ??/?? "D4" m/d/yy or m/d/yy h:mm or mm/dd/yy "D1" d-mmm-yy or dd-mmm-yy "D2" d-mmm or dd-mmm "D3" mmm-yy "D5" mm/dd "D6" h:mm:ss AM/PM "D7" h:mm AM/PM "D8" h:mm:ss "D9" h:mm range is the cell (or range) that you wish to retrieve information for. If the range parameter is omitted, the Cell function will assume that you are retrieving information for the last cell that was changed
In Excel, the Error.Type function returns the numeric representation of one of the errors in Excel. The syntax for the Error.Type function is: Error.Type( error_value ) error_value is an error value in Excel. error_value can be one of the following values: error_value Returned #NULL! 1 #DIV/0! 2 #VALUE! 3 #REF! 4 #NAME? 5 #NUM! 6 All other values #N/A
In Excel, the Info function returns information about the operating environment. The syntax for the Info function is: Info( type ) type is the type of information that you wish to retrieve about the operating environment. type can be one of the following values: Value Explanation "directory" Path of the current directory. "memavail" Amount of memory available (bytes). "memused" Amount of memory being used (bytes). "numfile" Number of active worksheets. "origin" The cell that is in the top, left-most cell visible in the current Excel spreadsheet. "osversion" Operating system version. "recalc" Returns the recalculation mode - either Automatic or Manual. "release" Version of Excel that you are running. "system" Name of the operating environment. "totmem" Total memory. For example: Let's take a look at a few examples: =Info("directory") =Info("osversion") =Info("release")
In Excel, the IsBlank function can be used to check for blank or null values. The syntax for the IsBlank function is: IsBlank( value ) value is the value that you want to test. If value is blank, this function will return TRUE. If value is not blank, the function will return FALSE.
In Excel, the IsDate function returns TRUE if the expression is a valid date. Otherwise, it returns FALSE. The syntax for the IsDate function is: IsDate( expression ) expression is a variant. For example: IsDate("1/3/2004") would return TRUE IsDate("Tech on the Net") would return FALSE IsDate("January 3, 2004") would return TRUE VBA Code The IsDate function can only be used in VBA code. For example: Dim LValue As Boolean LValue = IsDate("Tech on the Net") In this example, the variable called LValue would contain FALSE as a value
In Excel, the IsErr function can be used to check for error values. The syntax for the IsErr function is: IsErr( value ) value is the value that you want to test. If value is an error value (except #N/A), this function will return TRUE. Otherwise, it will return FALSE
In Excel, the IsError function can be used to check for error values. The syntax for the IsError function is: IsError( value ) value is the value that you want to test. If value is an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL), this function will return TRUE. Otherwise, it will return FALSE.
In Excel, the IsLogical function can be used to check for a logical value (ie: TRUE or FALSE). The syntax for the IsLogical function is: IsLogical( value ) value is the value that you want to test. If value is a TRUE or FALSE value , this function will return TRUE. Otherwise, it will return FALSE.
In Excel, the IsNA function can be used to check for a #N/A (value not available) error. The syntax for the IsNA function is: IsNA( value ) value is the value that you want to test. If value is a #N/A error value , this function will return TRUE. Otherwise, it will return FALSE
In Excel, the IsNonText function can be used to check for a value that is not text. The syntax for the IsNonText function is: IsNonText( value ) value is the value that you want to test. If value is not text, this function will return TRUE. Otherwise, it will return FALSE
In Excel, the IsNull function returns TRUE if the expression is a null value. Otherwise, it returns FALSE. The syntax for the IsNull function is: IsNull( expression ) expression is a variant that contains a string or numeric value. For example: IsNull(null) would return TRUE IsNull("Tech on the Net") would return FALSE VBA Code The IsNull function can only be used in VBA code. For example: Dim LValue As Boolean LValue = IsNull("Tech on the Net") In this example, the variable called LValue would contain FALSE as a value.
In Excel, the IsNumber function can be used to check for a numeric value. The syntax for the IsNumber function is: IsNumber( value ) value is the value that you want to test. If value is a numeric value , this function will return TRUE. Otherwise, it will return FALSE.
In Excel, the IsNumeric function returns TRUE if the expression is a valid number. Otherwise, it returns FALSE. The syntax for the IsNumeric function is: IsNumeric( expression ) expression is a variant. For example: IsNumeric(786) would return TRUE IsNumeric("Tech on the Net") would return FALSE IsNumeric("234") would return TRUE VBA Code The IsNumeric function can only be used in VBA code. For example: Dim LValue As Boolean LValue = IsNumeric("Tech on the Net") In this example, the variable called LValue would contain FALSE as a value.
In Excel, the IsRef function can be used to check for a reference. The syntax for the IsRef function is: IsRef( value ) value is the value that you want to test. If value is a reference, this function will return TRUE. Otherwise, it will return FALSE.
In Excel, the IsText function can be used to check for a text value. The syntax for the IsText function is: IsText( value ) value is the value that you want to test. If value is a text value, this function will return TRUE. Otherwise, it will return FALSE.
In Excel, the N function converts a value to a number. The syntax for the N function is: N( value ) value is a value to convert to a number. Note: If value is a number, the N function returns a number. If value is a date, the N function returns the date as a serial number. If value is TRUE, the N function will return 1. If value is FALSE, the N function will return 0. If value is an error, the error value is returned. For all other values, the N function will return 0
In Excel, the Type function returns the type of a value. The syntax for the Type function is: Type( value ) value can be text, numbers, logical values (TRUE or FALSE), arrays, or errors. Value Returned Number 1 Text 2 Logical value (ie: TRUE or FALSE) 4 Error value 16 Array 64
