4D v17
TYPE
- 4D View Pro
-
- Formules 4D View Pro
-
- Opérateurs et valeurs
- Références des cellules
- Conversion des formules du plug-in 4D View
- ABS
- ACOS
- AND
- ASIN
- ATAN
- AVERAGE
- COLUMNLETTER
- COS
- COUNTA
- EXP
- FALSE
- FINDCELL
- FV
- IF
- INDIRECT
- ISBLANK
- LEN
- LN
- LOOKUP
- MAX
- MID
- MIN
- NOT
- NOW
- NPER
- OR
- PI
- PMT
- PV
- RAND
- RATE
- ROUND
- ROW
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
4D v17
TYPE
TYPE
| TYPE ( value ) | ||||||||
| Paramètre | Type | Description | ||||||
| value |
|
Value to evaluate | ||||||
The TYPE function returns the type of value as a number.
Returned types are listed below:
| Type of value | Returned number |
| Number | 1 |
| DateTime object | 1 |
| TimeSpan object | 1 |
| Text | 2 |
| Boolean | 4 |
| Error | 16 |
| Array | 64 |
Use the TYPE function when the execution of another function depends on the type of value contained in a specific cell. The TYPE function is particularly useful when calling functions that accept different types of data.
TYPE(G15)
TYPE(42) //1
TYPE("String") //2
TYPE(TRUE) //4
PROPRIÉTÉS
Produit : 4D
Thème : Formules 4D View Pro
Nom intl. : TYPE
HISTORIQUE
UTILISATION DE L'ARTICLE
4D View Pro ( 4D v17)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.