123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438 |
- GETPIVOTDATA = LIREDONNEESTABCROISDYNAMIQUE
- CUBEKPIMEMBER = MEMBREKPICUBE
- CUBEMEMBER = MEMBRECUBE
- CUBEMEMBERPROPERTY = PROPRIETEMEMBRECUBE
- CUBERANKEDMEMBER = RANGMEMBRECUBE
- CUBESET = JEUCUBE
- CUBESETCOUNT = NBJEUCUBE
- CUBEVALUE = VALEURCUBE
- DAVERAGE = BDMOYENNE
- DCOUNT = BCOMPTE
- DCOUNTA = BDNBVAL
- DGET = BDLIRE
- DMAX = BDMAX
- DMIN = BDMIN
- DPRODUCT = BDPRODUIT
- DSTDEV = BDECARTYPE
- DSTDEVP = BDECARTYPEP
- DSUM = BDSOMME
- DVAR = BDVAR
- DVARP = BDVARP
- DATE = DATE
- DATEVALUE = DATEVAL
- DAY = JOUR
- DAYS360 = JOURS360
- EDATE = MOIS.DECALER
- EOMONTH = FIN.MOIS
- HOUR = HEURE
- MINUTE = MINUTE
- MONTH = MOIS
- NETWORKDAYS = NB.JOURS.OUVRES
- NOW = MAINTENANT
- SECOND = SECONDE
- TIME = TEMPS
- TIMEVALUE = TEMPSVAL
- TODAY = AUJOURDHUI
- WEEKDAY = JOURSEM
- WEEKNUM = NO.SEMAINE
- WORKDAY = SERIE.JOUR.OUVRE
- YEAR = ANNEE
- YEARFRAC = FRACTION.ANNEE
- BESSELI = BESSELI
- BESSELJ = BESSELJ
- BESSELK = BESSELK
- BESSELY = BESSELY
- BIN2DEC = BINDEC
- BIN2HEX = BINHEX
- BIN2OCT = BINOCT
- COMPLEX = COMPLEXE
- CONVERT = CONVERT
- DEC2BIN = DECBIN
- DEC2HEX = DECHEX
- DEC2OCT = DECOCT
- DELTA = DELTA
- ERF = ERF
- ERFC = ERFC
- GESTEP = SUP.SEUIL
- HEX2BIN = HEXBIN
- HEX2DEC = HEXDEC
- HEX2OCT = HEXOCT
- IMABS = COMPLEXE.MODULE
- IMAGINARY = COMPLEXE.IMAGINAIRE
- IMARGUMENT = COMPLEXE.ARGUMENT
- IMCONJUGATE = COMPLEXE.CONJUGUE
- IMCOS = IMCOS
- IMDIV = COMPLEXE.DIV
- IMEXP = COMPLEXE.EXP
- IMLN = COMPLEXE.LN
- IMLOG10 = COMPLEXE.LOG10
- IMLOG2 = COMPLEXE.LOG2
- IMPOWER = COMPLEXE.PUISSANCE
- IMPRODUCT = COMPLEXE.PRODUIT
- IMREAL = COMPLEXE.REEL
- IMSIN = COMPLEXE.SIN
- IMSQRT = COMPLEXE.RACINE
- IMSUB = COMPLEXE.DIFFERENCE
- IMSUM = COMPLEXE.SOMME
- OCT2BIN = OCTBIN
- OCT2DEC = OCTDEC
- OCT2HEX = OCTHEX
- ACCRINT = INTERET.ACC
- ACCRINTM = INTERET.ACC.MAT
- AMORDEGRC = AMORDEGRC
- AMORLINC = AMORLINC
- COUPDAYBS = NB.JOURS.COUPON.PREC
- COUPDAYS = NB.JOURS.COUPONS
- COUPDAYSNC = NB.JOURS.COUPON.SUIV
- COUPNCD = DATE.COUPON.SUIV
- COUPNUM = NB.COUPONS
- COUPPCD = DATE.COUPON.PREC
- CUMIPMT = CUMUL.INTER
- CUMPRINC = CUMUL.PRINCPER
- DB = DB
- DDB = DDB
- DISC = TAUX.ESCOMPTE
- DOLLARDE = PRIX.DEC
- DOLLARFR = PRIX.FRAC
- DURATION = DUREE
- EFFECT = TAUX.EFFECTIF
- FV = VC
- FVSCHEDULE = VC.PAIEMENTS
- INTRATE = TAUX.INTERET
- IPMT = INTPER
- IRR = TRI
- ISPMT = ISPMT
- MDURATION = DUREE.MODIFIEE
- MIRR = TRIM
- NOMINAL = TAUX.NOMINAL
- NPER = NPM
- NPV = VAN
- ODDFPRICE = PRIX.PCOUPON.IRREG
- ODDFYIELD = REND.PCOUPON.IRREG
- ODDLPRICE = PRIX.DCOUPON.IRREG
- ODDLYIELD = REND.DCOUPON.IRREG
- PMT = VPM
- PPMT = PRINCPER
- PRICE = PRIX.TITRE
- PRICEDISC = VALEUR.ENCAISSEMENT
- PRICEMAT = PRIX.TITRE.ECHEANCE
- PV = PV
- RATE = TAUX
- RECEIVED = VALEUR.NOMINALE
- SLN = AMORLIN
- SYD = SYD
- TBILLEQ = TAUX.ESCOMPTE.R
- TBILLPRICE = PRIX.BON.TRESOR
- TBILLYIELD = RENDEMENT.BON.TRESOR
- VDB = VDB
- XIRR = TRI.PAIEMENTS
- XNPV = VAN.PAIEMENTS
- YIELD = RENDEMENT.TITRE
- YIELDDISC = RENDEMENT.SIMPLE
- YIELDMAT = RENDEMENT.TITRE.ECHEANCE
- CELL = CELLULE
- ERROR.TYPE = TYPE.ERREUR
- INFO = INFORMATIONS
- ISBLANK = ESTVIDE
- ISERR = ESTERR
- ISERROR = ESTERREUR
- ISEVEN = EST.PAIR
- ISLOGICAL = ESTLOGIQUE
- ISNA = ESTNA
- ISNONTEXT = ESTNONTEXTE
- ISNUMBER = ESTNUM
- ISODD = EST.IMPAIR
- ISREF = ESTREF
- ISTEXT = ESTTEXTE
- N = N
- NA = NA
- TYPE = TYPE
- AND = ET
- FALSE = FAUX
- IF = SI
- IFERROR = SIERREUR
- NOT = NON
- OR = OU
- TRUE = VRAI
- ADDRESS = ADRESSE
- AREAS = ZONES
- CHOOSE = CHOISIR
- COLUMN = COLONNE
- COLUMNS = COLONNES
- HLOOKUP = RECHERCHEH
- HYPERLINK = LIEN_HYPERTEXTE
- INDEX = INDEX
- INDIRECT = INDIRECT
- LOOKUP = RECHERCHE
- MATCH = EQUIV
- OFFSET = DECALER
- ROW = LIGNE
- ROWS = LIGNES
- RTD = RTD
- TRANSPOSE = TRANSPOSE
- VLOOKUP = RECHERCHEV
- ABS = ABS
- ACOS = ACOS
- ACOSH = ACOSH
- ASIN = ASIN
- ASINH = ASINH
- ATAN = ATAN
- ATAN2 = ATAN2
- ATANH = ATANH
- CEILING = PLAFOND
- COMBIN = COMBIN
- COS = COS
- COSH = COSH
- DEGREES = DEGRES
- EVEN = PAIR
- EXP = EXP
- FACT = FACT
- FACTDOUBLE = FACTDOUBLE
- FLOOR = PLANCHER
- GCD = PGCD
- INT = ENT
- LCM = PPCM
- LN = LN
- LOG = LOG
- LOG10 = LOG10
- MDETERM = DETERMAT
- MINVERSE = INVERSEMAT
- MMULT = PRODUITMAT
- MOD = MOD
- MROUND = ARRONDI.AU.MULTIPLE
- MULTINOMIAL = MULTINOMIALE
- ODD = IMPAIR
- PI = PI
- POWER = PUISSANCE
- PRODUCT = PRODUIT
- QUOTIENT = QUOTIENT
- RADIANS = RADIANS
- RAND = ALEA
- RANDBETWEEN = ALEA.ENTRE.BORNES
- ROMAN = ROMAIN
- ROUND = ARRONDI
- ROUNDDOWN = ARRONDI.INF
- ROUNDUP = ARRONDI.SUP
- SERIESSUM = SOMME.SERIES
- SIGN = SIGNE
- SIN = SIN
- SINH = SINH
- SQRT = RACINE
- SQRTPI = RACINE.PI
- SUBTOTAL = SOUS.TOTAL
- SUM = SOMME
- SUMIF = SOMME.SI
- SUMIFS = SOMME.SI.ENS
- SUMPRODUCT = SOMMEPROD
- SUMSQ = SOMME.CARRES
- SUMX2MY2 = SOMME.X2MY2
- SUMX2PY2 = SOMME.X2PY2
- SUMXMY2 = SOMME.XMY2
- TAN = TAN
- TANH = TANH
- TRUNC = TRONQUE
- AVEDEV = ECART.MOYEN
- AVERAGE = MOYENNE
- AVERAGEA = AVERAGEA
- AVERAGEIF = MOYENNE.SI
- AVERAGEIFS = MOYENNE.SI.ENS
- BETADIST = LOI.BETA
- BETAINV = BETA.INVERSE
- BINOMDIST = LOI.BINOMIALE
- CHIDIST = LOI.KHIDEUX
- CHIINV = KHIDEUX.INVERSE
- CHITEST = TEST.KHIDEUX
- CONFIDENCE = INTERVALLE.CONFIANCE
- CORREL = COEFFICIENT.CORRELATION
- COUNT = NB
- COUNTA = NBVAL
- COUNTBLANK = NB.VIDE
- COUNTIF = NB.SI
- COUNTIFS = NB.SI.ENS
- COVAR = COVARIANCE
- CRITBINOM = CRITERE.LOI.BINOMIALE
- DEVSQ = SOMME.CARRES.ECARTS
- EXPONDIST = LOI.EXPONENTIELLE
- FDIST = LOI.F
- FINV = INVERSE.LOI.F
- FISHER = FISHER
- FISHERINV = FISHER.INVERSE
- FORECAST = PREVISION
- FREQUENCY = FREQUENCE
- FTEST = TEST.F
- GAMMADIST = LOI.GAMMA
- GAMMAINV = LOI.GAMMA.INVERSE
- GAMMALN = LNGAMMA
- GEOMEAN = MOYENNE.GEOMETRIQUE
- GROWTH = CROISSANCE
- HARMEAN = MOYENNE.HARMONIQUE
- HYPGEOMDIST = LOI.HYPERGEOMETRIQUE
- INTERCEPT = ORDONNEE.ORIGINE
- KURT = KURTOSIS
- LARGE = GRANDE.VALEUR
- LINEST = DROITEREG
- LOGEST = LOGREG
- LOGINV = LOI.LOGNORMALE.INVERSE
- LOGNORMDIST = LOI.LOGNORMALE
- MAX = MAX
- MAXA = MAXA
- MEDIAN = MEDIANE
- MIN = MIN
- MINA = MINA
- MODE = MODE
- NEGBINOMDIST = LOI.BINOMIALE.NEG
- NORMDIST = LOI.NORMALE
- NORMINV = LOI.NORMALE.INVERSE
- NORMSDIST = LOI.NORMALE.STANDARD
- NORMSINV = LOI.NORMALE.STANDARD.INVERSE
- PEARSON = PEARSON
- PERCENTILE = CENTILE
- PERCENTRANK = RANG.POURCENTAGE
- PERMUT = PERMUTATION
- POISSON = LOI.POISSON
- PROB = PROBABILITE
- QUARTILE = QUARTILE
- RANK = RANG
- RSQ = COEFFICIENT.DETERMINATION
- SKEW = COEFFICIENT.ASYMETRIE
- SLOPE = PENTE
- SMALL = PETITE.VALEUR
- STANDARDIZE = CENTREE.REDUITE
- STDEV = ECARTYPE
- STDEVA = STDEVA
- STDEVP = ECARTYPEP
- STDEVPA = STDEVPA
- STEYX = ERREUR.TYPE.XY
- TDIST = LOI.STUDENT
- TINV = LOI.STUDENT.INVERSE
- TREND = TENDANCE
- TRIMMEAN = MOYENNE.REDUITE
- TTEST = TEST.STUDENT
- VAR = VAR
- VARA = VARA
- VARP = VAR.P
- VARPA = VARPA
- WEIBULL = LOI.WEIBULL
- ZTEST = TEST.Z
- ASC = ASC
- BAHTTEXT = BAHTTEXT
- CHAR = CAR
- CLEAN = EPURAGE
- CODE = CODE
- CONCATENATE = CONCATENER
- DOLLAR = EURO
- EXACT = EXACT
- FIND = TROUVE
- FINDB = TROUVERB
- FIXED = CTXT
- JIS = JIS
- LEFT = GAUCHE
- LEFTB = GAUCHEB
- LEN = NBCAR
- LENB = LENB
- LOWER = MINUSCULE
- MID = STXT
- MIDB = STXTB
- PHONETIC = PHONETIQUE
- PROPER = NOMPROPRE
- REPLACE = REMPLACER
- REPLACEB = REMPLACERB
- REPT = REPT
- RIGHT = DROITE
- RIGHTB = DROITEB
- SEARCH = CHERCHE
- SEARCHB = CHERCHERB
- SUBSTITUTE = SUBSTITUE
- T = T
- TEXT = TEXTE
- TRIM = SUPPRESPACE
- UPPER = MAJUSCULE
- VALUE = CNUM
|