Information Funktionen
[ ] indicates optional parameters
FEHLER.TYP(Fehlerwert)
INFO(Typ)
ISTBEZUG(Wert)
ISTFEHL(Wert)
ISTFEHLER(Wert)
ISTGERADE(Zahl)
ISTKTEXT(Wert)
ISTLEER(Wert)
ISTLOG(Wert)
ISTNV(Wert)
ISTTEXT(Wert)
ISTUNGERADE(Zahl)
ISTZAHL(Wert)
N(Wert)
NV()
TYP(Wert)
ZELLE(Infotyp; [Bezug])
Information Funktionen
FEHLER.TYP(Fehlerwert)
Returns a number corresponding to the type of the error.
| Fehlerwert | The error value, or cell containing the error value, that you want to check. |
| The returned values are: |
|
| #NULL! | 1 |
| #DIV/0! | 2 |
| #WERT! | 3 |
| #BEZUG! | 4 |
| #NAME? | 5 |
| #ZAHL! | 6 |
| #NV | 7 |
| other | #NV |
|
INFO(Typ)
Returns information about the current spreadsheet.
| Typ | The type of information you want returned. The possible values are: |
|
| "BENUTZTSPEICH" | The number of bytes of memory used |
| "DATEIENZAHL" | The number of spreadsheet files that are open |
| "GESAMTSPEICH" | The total number of bytes of memory |
| "RECHENMODUS" | A string containing "Automatic" or "Manual", depending on the recalculation mode |
| "SYSTEM" | The operating system type |
| "SYSVERSION" | The operating system version number |
| "URSPRUNG" | A string containing the address of the cell in the top-left corner of the scrollable region |
| "VERFSPEICH" | The number of bytes of memory available |
| "VERSION" | The release version with which this program is compatible |
| "VERZEICHNIS" | The path of the current directory |
|
ISTBEZUG(Wert)
Returns WAHR if the value is a reference, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTFEHL(Wert)
Returns WAHR if the value is an error other than #NV, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTFEHLER(Wert)
Returns WAHR if the value is an error, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTGERADE(Zahl)
Returns WAHR if the number is even, otherwise FALSCH.
| Zahl | The number you want to check. |
ISTKTEXT(Wert)
Returns WAHR if the value is not a string, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTLEER(Wert)
Returns WAHR if the value is a reference to an empty cell, otherwise FALSCH.
| Wert | The cell whose value you want to check. |
ISTLOG(Wert)
Returns WAHR if the value is a logical value, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTNV(Wert)
Returns WAHR if the value is the error #NV, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTTEXT(Wert)
Returns WAHR if the value is a string, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
ISTUNGERADE(Zahl)
Returns WAHR if the number is odd, otherwise FALSCH.
| Zahl | The number you want to check. |
ISTZAHL(Wert)
Returns WAHR if the value is a number, otherwise FALSCH.
| Wert | The expression whose result you want to check. |
N(Wert)
Returns a number corresponding to the input value, or 0 if the input value is a string. You should not need to use this function, as values are automatically converted where necessary when they are used in formulas.
| Wert | The value you want as a number. |
NV()
Returns the error value #NV.
TYP(Wert)
Returns a number corresponding to the type of the value.
| Wert | The value, or cell containing the value, that you want to check. |
| The returned values are: |
|
| Zahl | 1 |
| Text | 2 |
| Logisch | 4 |
| Fehler | 16 |
| Array | 64 |
|
ZELLE(Infotyp; [Bezug])
Returns information about a worksheet cell.
| Infotyp | The type of information you want returned. The possible values are: |
|
| "ADRESSE" | A string containing the cell reference |
| "BREITE" | The cell width in characters |
| "DATEINAME" | The path, filename and sheet name of the cell |
| "FARBE" | 1 if the cell is formatted in color for negative values, otherwise 0 (not currently implemented) |
| "FORMAT" | The number format that has been applied to the cell |
| "INHALT" | The result of the formula in the cell, or 0 if the cell is empty |
| "KLAMMERN" | 1 if the cell is formatted in parentheses for positive values, otherwise 0 (not currently implemented) |
| "PRÄFIX" | The text alignment that has been applied to the cell (not currently implemented) |
| "SCHUTZ" | 1 if the cell is locked, otherwise 0 |
| "SPALTE" | The column number of the cell |
| "TYP" | A string representing the type of the cell result: "b" for blank, "l" for label (string), otherwise "v" |
| "ZEILE" | The row number of the cell |
|
| Bezug | The cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula. |