Fonctions Information

[ ] indicates optional parameters

CELLULE(type_info; [référence])
EST.IMPAIR(nombre)
EST.PAIR(nombre)
ESTERR(valeur)
ESTERREUR(valeur)
ESTLOGIQUE(valeur)
ESTNA(valeur)
ESTNONTEXTE(valeur)
ESTNUM(valeur)
ESTREF(valeur)
ESTTEXTE(valeur)
ESTVIDE(valeur)
INFO(type_texte)
N(valeur)
NA()
NB.VIDE(plage)
TYPE(valeur)
TYPE.ERREUR(valeur)


Fonctions Information

CELLULE(type_info; [référence])

Returns information about a worksheet cell.

type_infoThe type of information you want returned. The possible values are:
"ADRESSE"A string containing the cell reference
"COLONNE"The column number of the cell
"CONTENU"The result of the formula in the cell, or 0 if the cell is empty
"COULEUR"1 if the cell is formatted in color for negative values, otherwise 0 (not currently implemented)
"NOMFICHIER"The path, filename and sheet name of the cell
"FORMAT"The number format that has been applied to the cell
"LARGEUR"The cell width in characters
"LIGNE"The row number of the cell
"PARENTHESES"1 if the cell is formatted in parentheses for positive values, otherwise 0 (not currently implemented)
"PREFIXE"The text alignment that has been applied to the cell (not currently implemented)
"PROTEGE"1 if the cell is locked, otherwise 0
"TYPE"A string representing the type of the cell result: "b" for blank, "l" for label (string), otherwise "v"
référenceThe cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula.


EST.IMPAIR(nombre)

Returns VRAI if the number is odd, otherwise FAUX.

nombreThe number you want to check.


EST.PAIR(nombre)

Returns VRAI if the number is even, otherwise FAUX.

nombreThe number you want to check.


ESTERR(valeur)

Returns VRAI if the value is an error other than #N/A, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTERREUR(valeur)

Returns VRAI if the value is an error, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTLOGIQUE(valeur)

Returns VRAI if the value is a logical value, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTNA(valeur)

Returns VRAI if the value is the error #N/A, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTNONTEXTE(valeur)

Returns VRAI if the value is not a string, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTNUM(valeur)

Returns VRAI if the value is a number, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTREF(valeur)

Returns VRAI if the value is a reference, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTTEXTE(valeur)

Returns VRAI if the value is a string, otherwise FAUX.

valeurThe expression whose result you want to check.


ESTVIDE(valeur)

Returns VRAI if the value is a reference to an empty cell, otherwise FAUX.

valeurThe cell whose value you want to check.


INFO(type_texte)

Returns information about the current spreadsheet.

type_texteThe type of information you want returned. The possible values are:
"REPERTOIRE"The path of the current directory
"MEMDISPO"The number of bytes of memory available
"MEMUTIL"The number of bytes of memory used
"NBFICH"The number of spreadsheet files that are open
"CELLULE"A string containing the address of the cell in the top-left corner of the scrollable region
"VERSIONSE"The operating system version number
"RECALCUL"A string containing "Automatic" or "Manual", depending on the recalculation mode
"VERSION"The release version with which this program is compatible
"SYSTEXPL"The operating system type
"MEMTOT"The total number of bytes of memory


N(valeur)

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.

valeurThe value you want as a number.


NA()

Returns the error value #N/A.



NB.VIDE(plage)

Returns the number of blank cells in a range.

plageThe reference of the cells you want to check.


TYPE(valeur)

Returns a number corresponding to the type of the value.

valeurThe value, or cell containing the value, that you want to check.
The returned values are:
nombre1
texte2
logique4
erreur16
matrice64


TYPE.ERREUR(valeur)

Returns a number corresponding to the type of the error.

valeurThe error value, or cell containing the error value, that you want to check.
The returned values are:
#NULL!1
#DIV/0!2
#VALUE!3
#REF!4
#NAME?5
#NUM!6
#N/A7
other#N/A