Fonctions Information
[ ] indicates optional parameters
CELLULE(type_info; [référence])CELLULE(type_info; [référence])
Returns information about a worksheet cell.
type_info | The type of information you want returned. The possible values are: | ||||||||||||||||||||||||
| |||||||||||||||||||||||||
référence | The cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula. |
Returns VRAI if the number is odd, otherwise FAUX.
nombre | The number you want to check. |
Returns VRAI if the number is even, otherwise FAUX.
nombre | The number you want to check. |
Returns VRAI if the value is an error other than #N/A, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is an error, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is a logical value, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is the error #N/A, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is not a string, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is a number, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is a reference, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is a string, otherwise FAUX.
valeur | The expression whose result you want to check. |
Returns VRAI if the value is a reference to an empty cell, otherwise FAUX.
valeur | The cell whose value you want to check. |
Returns information about the current spreadsheet.
type_texte | The type of information you want returned. The possible values are: | ||||||||||||||||||||
|
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.
valeur | The value you want as a number. |
Returns the error value #N/A.
Returns the number of blank cells in a range.
plage | The reference of the cells you want to check. |
Returns a number corresponding to the type of the value.
valeur | The value, or cell containing the value, that you want to check. | ||||||||||
The returned values are: | |||||||||||
|
Returns a number corresponding to the type of the error.
valeur | The error value, or cell containing the error value, that you want to check. | ||||||||||||||||
The returned values are: | |||||||||||||||||
|