Information Functions
- 2 minutes to read
This document describes information functions supported by the WinForms Spreadsheet control.
Name | Description | Syntax |
---|---|---|
Returns information about the formatting, location, or contents of a cell. | CELL | |
Returns a number corresponding to one of error values or returns #N/A if no error exists. | ERROR. | |
Returns information about the current operating environment. | INFO | |
Checks whether a value refers to an empty cell. | ISBLANK | |
Checks whether a value or expression returns an error except #N/A. | ISERR | |
Checks whether a value or expression returns any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). | ISERROR | |
Checks whether the number is even. | ISEVEN | |
Checks whether the referenced cell contains formula. | ISFORMULA | |
Checks whether a value is a logical value. | ISLOGICAL | |
Checks whether a value or expression returns the #N/A error. | ISNA | |
Checks whether a value or expression is not text. | ISNONTEXT | |
Checks whether a value or expression is a number. | ISNUMBER | |
Checks whether the number is odd. | ISODD | |
Checks whether a value is a reference. | ISREF | |
Checks whether a value or expression is text. | ISTEXT | |
Returns a value converted to a number. | N | |
Returns the error value #N/A. | NA() | |
Returns the sheet number of the referenced sheet. | SHEET The value parameter is optional. It is the name of a sheet or a reference for which to obtain the sheet number. If the value is omitted, the number of the sheet that contains the function is returned. | |
Returns the number of sheets in a reference. | SHEETS The reference parameter is optional. If the parameter is omitted, the number of sheets in the workbook that contains the function is returned. | |
Returns the type of value. | TYPE |