L'automatisation Excel de TimeTonic ne supporte pas encore toutes les fonctions d'Excel.
Afin de vous aider à manipuler l'automatisation Excel via TimeTonic, voici une liste exhaustive des fonctions supportées (liste en anglais) :
| Category | Name | Example | Result |
| MATH | ABS | ABS(-4) | 4,0000 |
| FINANCIAL | ACCRINT | ACCRINT('01/01/2011', '02/01/2011', '07/01/2014', 0.1, 1000, 1, 0) | 350,0000 |
| MATH | ACOS | ACOS(-0.5) | 2,0944 |
| MATH | ACOSH | ACOSH(10) | 2,9932 |
| MATH | ACOT | ACOT(2) | 0,4636 |
| MATH | ACOTH | ACOTH(6) | 0,1682 |
| MATH | ADD | ADD(1,2) | 3,0000 |
| MATH | AGGREGATE | AGGREGATE(9, 4, [-5,15], [32,'Hello World!']) | 10,3200 |
| LOGICAL | AND | AND(true, false, true) | FALSE |
| MATH | ARABIC | ARABIC('MCMXII') | 1 912,0000 |
| MATH | ASIN | ASIN(-0.5) | -0,5236 |
| MATH | ASINH | ASINH(-2.5) | -1,6472 |
| MATH | ATAN | ATAN(1) | 0,7854 |
| MATH | ATAN2 | ATAN2(-1, -1) | -2,3562 |
| MATH | ATANH | ATANH(-0.1) | -0,1003 |
| STATISTICAL | AVEDEV | AVEDEV([2,4], [8,16]) | 4,5000 |
| STATISTICAL | AVERAGE | AVERAGE([2,4], [8,16]) | 7,5000 |
| STATISTICAL | AVERAGEA | AVERAGEA([2,4], [8,16]) | 7,5000 |
| STATISTICAL | AVERAGEIF | AVERAGEIF([2,4,8,16], '>5', [1, 2, 3, 4]) | 3,5000 |
| STATISTICAL | AVERAGEIFS | AVERAGEIFS([2,4,8,16], [1,2,3,4], '>=2', [1,2,4,8], '<=4') | 6,0000 |
| MATH | BASE | BASE(15, 2, 10) | 1 111,0000 |
| STATISTICAL | BETADIST / DIST | BETADIST(2, 8, 10, true, 1, 3) | 0,6855 |
| STATISTICAL | BETAINV | BETAINV(0.6854705810117458, 8, 10, 1, 3) | 2,0000 |
| ENGINEERING | BIN2DEC | BIN2DEC(101010) | 42,0000 |
| ENGINEERING | BIN2HEX | BIN2HEX(101010) | 2a |
| ENGINEERING | BIN2OCT | BIN2OCT(101010) | 52,0000 |
| STATISTICAL | BINOMDIST | BINOMDIST(6, 10, 0.5, false) | 0,2051 |
| ENGINEERING | BITAND | BITAND(42, 24) | 8,0000 |
| ENGINEERING | BITLSHIFT | BITLSHIFT(42, 24) | 704 643 072,0000 |
| ENGINEERING | BITOR | BITOR(42, 24) | 58,0000 |
| ENGINEERING | BITRSHIFT | BITRSHIFT(42, 2) | 10,0000 |
| ENGINEERING | BITXOR | BITXOR(42, 24) | 50,0000 |
| MATH | CEILING | CEILING(-5.5, 2, -1) | -6,0000 |
| MATH | CEILINGMATH | CEILINGMATH(-5.5, 2, -1) | -6,0000 |
| MATH | CEILINGPRECISE | CEILINGPRECISE(-4.1, -2) | -4,0000 |
| TEXT | CHAR | CHAR(65) | A |
| STATISTICAL | CHIDIST | CHIDIST() | |
| STATISTICAL | CHIDISTRT | CHIDISTRT | |
| STATISTICAL | CHIINV | CHIINV | |
| STATISTICAL | CHIINVRT | CHIINVRT | |
| STATISTICAL | CHITEST | CHITEST | |
| TEXT | CHOOSE | CHOOSE(2, "red", "blue", "orange") | blue |
| TEXT | CLEAN | CLEAN('Monthly report') | Monthly report |
| TEXT | CODE | CODE('A') | 65,0000 |
| MATH | COMBIN | COMBIN(8, 2) | 28,0000 |
| MATH | COMBINA | COMBINA(4, 3) | 20,0000 |
| ENGINEERING | COMPLEX | COMPLEX(3, 4) | 3+4i |
| TEXT | CONCATENATE / CONCAT | CONCATENATE('Andreas', ' ', 'Hauser') | Andreas Hauser |
| STATISTICAL | CONFIDENCE | CONFIDENCE | |
| ENGINEERING | CONVERT | CONVERT(64, 'kibyte', 'bit') | 524 288,0000 |
| STATISTICAL | CORREL | CORREL([3,2,4,5,6], [9,7,12,15,17]) | 0,9971 |
| MATH | COS | COS(1) | 0,5403 |
| MATH | COSH | COSH(1) | 1,5431 |
| MATH | COT | COT(30) | -0,1561 |
| MATH | COTH | COTH(2) | 1,0373 |
| STATISTICAL | COUNT | COUNT([1,2], [3,4]) | 4,0000 |
| STATISTICAL | COUNTA | COUNTA([1, null, 3, 'a', '', 'c']) | 4,0000 |
| STATISTICAL | COUNTBLANK | COUNTBLANK([1, null, 3, 'a', '', 'c']) | 2,0000 |
| STATISTICAL | COUNTIF | COUNTIF(['Caen', 'Melbourne', 'Palo Alto', 'Singapore'], 'a') | 3,0000 |
| STATISTICAL | COUNTIFS | COUNTIFS([2,4,8,16], [1,2,3,4], '>=2', [1,2,4,8], '<=4') | 2,0000 |
| STATISTICAL | COUNTIN | COUNTIN( | |
| STATISTICAL | COUNTUNIQUE | COUNTUNIQUE([1,1,2,2,3,3]) | 3,0000 |
| STATISTICAL | COVARIANCEP / COVAR | COVARIANCE.P([3,2,4,5,6], [9,7,12,15,17]) | 5,2000 |
| STATISTICAL | COVARIANCES | COVARIANCE.S([2,4,8], [5,11,12]) | 9,6667 |
| STATISTICAL | CRITBINOM | CRITBINOM | |
| MATH | CSC | CSC(15) | 1,5378 |
| MATH | CSCH | CSCH(1.5) | 0,4696 |
| FINANCIAL | CUMIPMT | CUMIPMT(0.1/12, 30*12, 100000, 13, 24, 0) | -9 916,7725 |
| FINANCIAL | CUMPRINC | CUMPRINC(0.1/12, 30*12, 100000, 13, 24, 0) | -614,0863 |
| DATE | DATE | DATE(2008, 7, 8) | Tue Jul 08 2008 00:00:00 GMT-0700 (PDT) |
| DATE | DATEDIF | DATEDIF("01/01/2001";01/01/2003;"Y") | 2,0000 |
| DATE | DATEVALUE | DATEVALUE('8/22/2011') | Mon Aug 22 2011 00:00:00 GMT-0700 (PDT) |
| DATE | DAY | DAY('15-Apr-11') | 15,0000 |
| DATE | DAYS | DAYS('3/15/11', '2/1/11') | 42,0000 |
| DATE | DAYS360 | DAYS360('1-Jan-11', '31-Dec-11') | 360,0000 |
| FINANCIAL | DB | DB(1000000, 100000, 6, 1, 6) | 159 500,0000 |
| FINANCIAL | DDB | DDB(1000000, 100000, 6, 1, 1.5) | 250 000,0000 |
| ENGINEERING | DEC2BIN | DEC2BIN(42) | 101 010,0000 |
| ENGINEERING | DEC2HEX | DEC2HEX(42) | 2a |
| ENGINEERING | DEC2OCT | DEC2OCT(42) | 52,0000 |
| MATH | DECIMAL | DECIMAL('FF', 16) | 255,0000 |
| MATH | DEGREES | DEGREES(PI()) | 180,0000 |
| ENGINEERING | DELTA | DELTA(42, 42) | 1,0000 |
| STATISTICAL | DEVSQ | DEVSQ([2,4,8,16]) | 115,0000 |
| MATH | DIVIDE | DIVIDE(10,5) | 2,0000 |
| TEXT | DOLLAR | DOLLAR(10) | $10 |
| FINANCIAL | DOLLARDE | DOLLARDE(1.1, 16) | 1,6250 |
| FINANCIAL | DOLLARFR | DOLLARFR(1.625, 16) | 1,1000 |
| MATH | E | e(1,2) | |
| DATE | EDATE | EDATE('1/15/11', -1) | Wed Dec 15 2010 00:00:00 GMT-0800 (PST) |
| FINANCIAL | EFFECT | EFFECT(0.1, 4) | 0,1038 |
| EOMONTH | EOMONTH("1/1/11",1) | 40 602,0000 | |
| MATH | EQ | EQ(5,5) | 1,0000 |
| ENGINEERING | ERF | ERF(1) | 0,8427 |
| MATH | ERF | ERF(1) | 0,8427 |
| STATISTICAL | ERF.PRECISE | ERF.PRECISE | |
| ENGINEERING | ERFC | ERFC(1) | 0,1573 |
| MATH | ERFC | ERFC(1) | 0,1573 |
| STATISTICAL | ERFC.PRECISE | ERFC.PRECISE | |
| LOGICAL | ERROR | ERROR("N/A") | 7,0000 |
| MATH | EVEN | EVEN(-1) | -2,0000 |
| TEXT | EXACT | EXACT('Word', 'word') | FALSE |
| MATH | EXP | EXP(1) | 2,7183 |
| STATISTICAL | EXPONDIST | EXPONDIST(0.2, 10, true) | 0,8647 |
| STATISTICAL | F.DIST.RT | F.DIST.RT | |
| STATISTICAL | F.INV.RT | F.INV.RT | |
| STATISTICAL | F.TEST | F.TEST | |
| MATH | FACT | FACT(5) | 120,0000 |
| MATH | FACTDOUBLE | FACTDOUBLE(7) | 105,0000 |
| LOGICAL | FALSE | FALSE() | FALSE |
| STATISTICAL | FDIST | FDIST(15.2069, 6, 4, false) | 0,0012 |
| TEXT | FIND | FIND('M', 'Miriam McGovern', 3) | 8,0000 |
| STATISTICAL | FINV | FINV(0.01, 6, 4) | 0,1093 |
| STATISTICAL | FISHER | FISHER(0.75) | 0,9730 |
| STATISTICAL | FISHERINV | FISHERINV(0.9729550745276566) | 0,7500 |
| TEXT | FIXED | FIXED(1000.001) | 1,000.001 |
| MATH | FLOOR | FLOOR(-3.1) | -4,0000 |
| MATH | FLOORMATH | FLOORMATH(-4.1, -2, -1) | -4,0000 |
| MATH | FLOORPRECISE | FLOORPRECISE(-3.1, -2) | -4,0000 |
| STATISTICAL | FORECAST | FORECAST(30, [6,7,9,15,21], [20,28,31,38,40]) | 10,6073 |
| STATISTICAL | FREQUENCY | FREQUENCY([79,85,78,85,50,81,95,88,97], [70,79,89]) | 1,2,4,2 |
| FINANCIAL | FV | FV(0.1/12, 10, -100, -1000, 0) | 2 124,8744 |
| FINANCIAL | FVSCHEDULE | FVSCHEDULE(100, [0.09,0.1,0.11]) | 133,0890 |
| STATISTICAL | GAMMA | GAMMA(2.5) | 1,3293 |
| STATISTICAL | GAMMA.DIST | GAMMA.DIST | |
| STATISTICAL | GAMMA.INV | GAMMA.INV | |
| STATISTICAL | GAMMALN | GAMMALN(10) | 12,8018 |
| STATISTICAL | GAMMALN.PRECISE | GAMMALN.PRECISE | |
| STATISTICAL | GAUSS | GAUSS(2) | 0,4772 |
| MATH | GCD | GCD(24, 36, 48) | 12,0000 |
| STATISTICAL | GEOMEAN | GEOMEAN([2,4], [8,16]) | 5,6569 |
| ENGINEERING | GESTEP | GESTEP(42, 24) | 1,0000 |
| STATISTICAL | GROWTH | GROWTH([2,4,8,16], [1,2,3,4], [5]) | 32,0000 |
| LOGICAL | GT | GT(10,9) | 1,0000 |
| MATH | GTE | GTE(10,2) | 1,0000 |
| STATISTICAL | HARMEAN | HARMEAN([2,4], [8,16]) | 4,2667 |
| ENGINEERING | HEX2BIN | HEX2BIN('2a') | 101 010,0000 |
| ENGINEERING | HEX2DEC | HEX2DEC('2a') | 42,0000 |
| ENGINEERING | HEX2OCT | HEX2OCT('2a') | 52,0000 |
| TEXT | HLOOKUP | HLOOKUP() | 1,0000 |
| DATE | HOUR | HOUR('7/18/2011 7:45:00 AM') | 7,0000 |
| TEXT | HTML2TEXT | HTML2TEXT("<p>test</p>") | test |
| STATISTICAL | HYPGEOM.DIST | HYPGEOM.DIST(1, 4, 8, 20, false) | 0,3633 |
| LOGICAL | IF | IF(true, 'Hello!', 'Goodbye!') | Hello! |
| LOGICAL | IFERROR | IFERROR('#DIV/0!', 'Error') | Error |
| LOGICAL | IFNA | IFNA('#N/A', 'Error') | Error |
| LOGICAL | IFS | IFS(false, 'Hello!', true, 'Goodbye!') | Goodbye! |
| ENGINEERING | IMABS | IMABS('3+4i') | 5,0000 |
| ENGINEERING | IMAGINARY | IMAGINARY('3+4i') | 4,0000 |
| ENGINEERING | IMARGUMENT | IMARGUMENT('3+4i') | 0,9273 |
| ENGINEERING | IMCONJUGATE | IMCONJUGATE('3+4i') | 3-4i |
| ENGINEERING | IMCOS | IMCOS('1+i') | 0.8337300251311491-0.9888977057628651i |
| ENGINEERING | IMCOSH | IMCOSH('1+i') | 0.8337300251311491+0.9888977057628651i |
| ENGINEERING | IMCOT | IMCOT('1+i') | 0.21762156185440265-0.8680141428959249i |
| ENGINEERING | IMCSC | IMCSC('1+i') | 0.6215180171704283-0.3039310016284264i |
| ENGINEERING | IMCSCH | IMCSCH('1+i') | 0.3039310016284264-0.6215180171704283i |
| ENGINEERING | IMDIV | IMDIV('1+2i', '3+4i') | 0.44+0.08i |
| ENGINEERING | IMEXP | IMEXP('1+i') | 1.4686939399158851+2.2873552871788423i |
| ENGINEERING | IMLN | IMLN('1+i') | 0.3465735902799727+0.7853981633974483i |
| ENGINEERING | IMLOG10 | IMLOG10('1+i') | 0.1505149978319906+0.3410940884604603i |
| ENGINEERING | IMLOG2 | IMLOG2('1+i') | 0.5000000000000001+1.1330900354567985i |
| ENGINEERING | IMPOWER | IMPOWER('1+i', 2) | 1.2246063538223775e-16+2.0000000000000004i |
| ENGINEERING | IMPRODUCT | IMPRODUCT('1+2i', '3+4i', '5+6i') | -85+20i |
| ENGINEERING | IMREAL | IMREAL('3+4i') | 3,0000 |
| ENGINEERING | IMSEC | IMSEC('1+i') | 0.4983370305551868+0.591083841721045i |
| ENGINEERING | IMSECH | IMSECH('1+i') | 0.4983370305551868-0.591083841721045i |
| ENGINEERING | IMSIN | IMSIN('1+i') | 1.2984575814159773+0.6349639147847361i |
| ENGINEERING | IMSINH | IMSINH('1+i') | 0.6349639147847361+1.2984575814159773i |
| ENGINEERING | IMSQRT | IMSQRT('1+i') | 1.0986841134678098+0.45508986056222733i |
| ENGINEERING | IMSUB | IMSUB('3+4i', '1+2i') | 2+2i |
| ENGINEERING | IMSUM | IMSUM('1+2i', '3+4i', '5+6i') | 9+12i |
| ENGINEERING | IMTAN | IMTAN('1+i') | 0.2717525853195117+1.0839233273386946i |
| INDEX | INDEX(1,[1,2,3]) | 1,0000 | |
| MATH | INT | INT(-8.9) | -9,0000 |
| STATISTICAL | INTERCEPT | INTERCEPT([2,3,9,1,8], [6,5,11,7,5]) | 0,0484 |
| DATE | INTERVAL | INTERVAL | |
| FINANCIAL | IPMT | IPMT(0.1/12, 6, 2*12, 100000, 1000000, 0) | 928,8236 |
| FINANCIAL | IRR | IRR([-75000,12000,15000,18000,21000,24000], 0.075) | 0,0572 |
| ISBLANK | ISBLANK('test') | ||
| LOGICAL | ISERROR | ISERROR('N/A') | 1,0000 |
| MATH | ISEVEN | ISEVEN(-2.5) | TRUE |
| LOGICAL | ISFORMULA | ISFORMULA("=CONCATENATE('hello','world')) | 1,0000 |
| LOGICAL | ISLOGICAL | ISLOGICAL(false) | 1,0000 |
| LOGICAL | ISNA | ISNA('n/a') | 1,0000 |
| LOGICAL | ISNONTEXT | ISNONTEXT(1) | 1,0000 |
| LOGICAL | ISNUMBER | ISNUMBER(1) | 1,0000 |
| MATH | ISOCEILING | ISOCEILING(-4.1, -2) | -4,0000 |
| MATH | ISODD | ISODD(-2.5) | FALSE |
| DATE | ISOWEEKNUM | ISOWEEKNUM('3/9/2012') | 10,0000 |
| FINANCIAL | ISPMT | ISPMT(0.1/12, 6, 2*12, 100000) | -625,0000 |
| LOGICAL | ISTEXT | ISTEXT("yes") | 1,0000 |
| STATISTICAL | KURT | KURT([3,4,5,2,3,4,5,6,4,7]) | -0,1518 |
| STATISTICAL | LARGE | LARGE([3,5,3,5,4,4,2,4,6,7], 3) | 5,0000 |
| MATH | LCM | LCM(24, 36, 48) | 144,0000 |
| TEXT | LEFT | LEFT('Sale Price', 4) | Sale |
| TEXT | LEN | LEN('Phoenix, AZ') | 11,0000 |
| STATISTICAL | LINEST | LINEST([1,9,5,7], [0,4,2,3], true, true) | 2,1000 |
| MATH | LN | LN(86) | 4,4543 |
| MATH | LN10 | LN10() | 2,3026 |
| MATH | LN2 | LN2() | 0,6931 |
| MATH | LOG | LOG(8, 2) | 3,0000 |
| MATH | LOG10 | LOG10(100000) | 5,0000 |
| LOG10E | LOG10E(10) | ||
| LOG2E | LOG2E(2) | ||
| STATISTICAL | LOGNORM.DIST | LOGNORM.DIST(4, 3.5, 1.2, true) | 0,0391 |
| STATISTICAL | LOGNORM.INV | LOGNORM.INV(0.0390835557068005, 3.5, 1.2, true) | 4,0000 |
| LOOKUP | LOOKUP(1, [1,2,3],1) | 1,0000 | |
| TEXT | LOWER | LOWER('E. E. Cummings') | e. e. cummings |
| MATH | LT | LT(10,1) | |
| MATH | LTE | LTE(10,1) | |
| TEXT | MATCH | MATCH() | |
| STATISTICAL | MAX | MAX([0.1,0.2], [0.4,0.8], [true, false]) | 0,8000 |
| STATISTICAL | MAXA | MAXA([0.1,0.2], [0.4,0.8], [true, false]) | 1,0000 |
| MATH | MDETERM | MDETERM({3,6;1,1}) | -3,0000 |
| STATISTICAL | MEDIAN | MEDIAN([1,2,3], [4,5,6]) | 3,5000 |
| TEXT | MID | MID('Fluid Flow', 7, 20) | Flow |
| STATISTICAL | MIN | MIN([0.1,0.2], [0.4,0.8], [true, false]) | 0,1000 |
| STATISTICAL | MINA | MINA([0.1,0.2], [0.4,0.8], [true, false]) | |
| MATH | MINUS | MINUS(3,1) | 2,0000 |
| DATE | MINUTE | MINUTE('2/1/2011 12:45:00 PM') | 45,0000 |
| MATH | MINVERSE | MINVERSE( | |
| FINANCIAL | MIRR | MIRR([-75000,12000,15000,18000,21000,24000], 0.1, 0.12) | 0,0797 |
| MATH | MMULT | MMULT | |
| MATH | MODE | MODE(3, -2) | -1,0000 |
| STATISTICAL | MODE.MULT | MODE.MULT([1,2,3,4,3,2,1,2,3]) | 2,3000 |
| STATISTICAL | MODE.SNGL | MODE.SNGL([1,2,3,4,3,2,1,2,3]) | 2,0000 |
| DATE | MONTH | MONTH('15-Apr-11') | 4,0000 |
| MATH | MROUND | MROUND(-10, -3) | -9,0000 |
| MATH | MULTINOMIAL | MULTINOMIAL(2, 3, 4) | 1 260,0000 |
| MATH | MULTIPLY | MULTIPLY(3,2) | 6,0000 |
| MATH | MUNIT | MUNIT | |
| LOGICAL | N | N(10) | 10,0000 |
| LOGICAL | NA | NA() | "N/A" |
| MATH | NE | NE(10,10) | |
| STATISTICAL | NEGBINOM.DIST | NEGBINOM.DIST | |
| DATE | NETWORKDAYS | NETWORKDAYS('10/1/2012', '3/1/2013', ['11/22/2012']) | 109,0000 |
| DATE | NETWORKDAYS.INTL | NETWORKDAYSINTL('1/1/2006', '2/1/2006', 7, ['1/2/2006']) | 23,0000 |
| FINANCIAL | NOMINAL | NOMINAL(0.1, 4) | 0,0965 |
| STATISTICAL | NORM.DIST | NORM.DIST(42, 40, 1.5, true) | 0,9088 |
| STATISTICAL | NORM.INV | NORM.INV(0.9087887802741321, 40, 1.5) | 42,0000 |
| STATISTICAL | NORM.S.DIST | NORMSDIST(1, true) | 0,8413 |
| STATISTICAL | NORM.S.INV | NORM.S.INV(0.8413447460685429) | 1,0000 |
| LOGICAL | NOT | NOT(true) | FALSE |
| DATE | NOW | NOW() | Thu Feb 20 2020 23:02:55 GMT+0100 |
| FINANCIAL | NPER | NPER(0.1/12, -100, -1000, 10000, 0) | 63,3939 |
| FINANCIAL | NPV | NPV(0.1, -10000, 2000, 4000, 8000) | 1 031,3503 |
| TEXT | NUMBERVALUE | NUMBERVALUE('2.500,27', ',', '.') | 2 500,2700 |
| ENGINEERING | OCT2BIN | OCT2BIN('52') | 101 010,0000 |
| ENGINEERING | OCT2DEC | OCT2DEC('52') | 42,0000 |
| ENGINEERING | OCT2HEX | OCT2HEX('52') | 2a |
| MATH | ODD | ODD(-1.5) | -3,0000 |
| LOGICAL | OR | OR(true, false, true) | TRUE |
| FINANCIAL | PDURATION | PDURATION(0.1, 1000, 2000) | 7,2725 |
| STATISTICAL | PEARSON | PEARSON([9,7,5,3,1], [10,6,1,5,3]) | 0,6994 |
| STATISTICAL | PERCENTILE.EXC | PERCENTILE.EXC([1,2,3,4], 0.3) | 1,5000 |
| STATISTICAL | PERCENTILE.INC | PERCENTILE.INC([1,2,3,4], 0.3) | 1,9000 |
| STATISTICAL | PERCENTRANK.EXC | PERCENTRANK.EXC([1,2,3,4], 2, 2) | 0,4000 |
| STATISTICAL | PERCENTRANK.INC | PERCENTRANK.INC([1,2,3,4], 2, 2) | 0,3300 |
| STATISTICAL | PERMUT | PERMUT(100, 3) | 970 200,0000 |
| STATISTICAL | PERMUTATIONA | PERMUTATIONA(4, 3) | 64,0000 |
| STATISTICAL | PHI | PHI(0.75) | 0,3011 |
| FINANCIAL | PMT | PMT(0.1/12, 2*12, 100000, 1000000, 0) | -42 426,0856 |
| STATISTICAL | POISSON.DIST | POISSON.DIST(2, 5, true) | 0,1247 |
| MATH | POWER / POW | POWER(5, 2) | 25,0000 |
| FINANCIAL | PPMT | PPMT(0.1/12, 6, 2*12, 100000, 1000000, 0) | -43 354,9092 |
| STATISTICAL | PROB | PROB([1,2,3,4], [0.1,0.2,0.2,0.1], 2, 3) | 0,4000 |
| MATH | PRODUCT | PRODUCT(5, 15, 30) | 2 250,0000 |
| TEXT | PROPER | PROPER('this is a TITLE') | This Is A Title |
| FINANCIAL | PV | PV(0.1/12, 2*12, 1000, 10000, 0) | -29 864,9503 |
| STATISTICAL | QUARTILE.EXC | QUARTILE.EXC([1,2,3,4], 1) | 1,2500 |
| STATISTICAL | QUARTILE.INC | QUARTILE.INC([1,2,3,4], 1) | 1,7500 |
| MATH | QUOTIENT | QUOTIENT(-10, 3) | -3,0000 |
| MATH | RADIANS | RADIANS(180) | 3,1416 |
| MATH | RAND | RAND() | [Random real number greater between 0 and 1] |
| MATH | RANDBETWEEN | RANDBETWEEN(-1, 1) | [Random integer between bottom and top] |
| STATISTICAL | RANK.AVG | RANK.AVG(4, [2,4,4,8,8,16], false) | 4,5000 |
| STATISTICAL | RANK.EQ | RANK.EQ(4, [2,4,4,8,8,16], false) | 4,0000 |
| FINANCIAL | RATE | RATE(2*12, -1000, -10000, 100000, 0, 0.1) | 0,0652 |
| TEXT | REGEXEXTRACT | REGEXEXTRACT('Palo Alto', 'Alto') | Alto |
| TEXT | REGEXMATCH | REGEXMATCH('Palo Alto', 'Alto') | TRUE |
| TEXT | REGEXREPLACE | REGEXREPLACE('Sutoiku', 'utoiku', 'TOIC') | STOIC |
| TEXT | REPLACE | REPLACE('abcdefghijk', 6, 5, '*') | abcde*k |
| TEXT | REPT | REPT('*-', 3) | *-*-*- |
| TEXT | RIGHT | RIGHT('Sale Price', 5) | Price |
| TEXT | ROMAN | ROMAN(499) | CDXCIX |
| MATH | ROUND | ROUND(626.3, -3) | 1 000,0000 |
| MATH | ROUNDDOWN | ROUNDDOWN(-3.14159, 2) | -3,1400 |
| MATH | ROUNDUP | ROUNDUP(-3.14159, 2) | -3,1500 |
| FINANCIAL | RRI | RRI(96,10000,11000) | 0,0010 |
| STATISTICAL | RSQ | RSQ([9,7,5,3,1], [10,6,1,5,3]) | 0,4891 |
| TEXT | SEARCH | SEARCH('margin', 'Profit Margin') | 8,0000 |
| MATH | SEC | SEC(45) | 1,9036 |
| MATH | SECH | SECH(45) | 0,0000 |
| DATE | SECOND | SECOND('2/1/2011 4:48:18 PM') | 18,0000 |
| MATH | SIN | SIN(1) | 0,8415 |
| MATH | SINH | SINH(1) | 1,1752 |
| STATISTICAL | SKEW | SKEW([3,4,5,2,3,4,5,6,4,7]) | 0,3595 |
| STATISTICAL | SKEW.P | SKEW.P([3,4,5,2,3,4,5,6,4,7]) | 0,3032 |
| FINANCIAL | SLN | SLN(30000, 7500, 10) | 2 250,0000 |
| STATISTICAL | SLOPE | SLOPE([1,9,5,7], [0,4,2,3]) | 2,0000 |
| STATISTICAL | SMALL | SMALL([3,5,3,5,4,4,2,4,6,7], 3) | 3,0000 |
| TEXT | SPLIT | SPLIT('A,B,C', ',') | A,B,C |
| MATH | SQRT | SQRT(16) | 4,0000 |
| MATH | SQRT1_2 | SQRT1_2() | 0,7071 |
| MATH | SQRT2 | SQRT2() | 1,4142 |
| MATH | SQRTPI | SQRTPI(2) | 2,5066 |
| STATISTICAL | STANDARDIZE | STANDARDIZE(42, 40, 1.5) | 1,3333 |
| STDEV | STDEV([2,4], [8,16], [true, false]) | 6,1914 | |
| STATISTICAL | STDEV.P | STDEV.P([2,4], [8,16], [true, false]) | 5,3619 |
| STATISTICAL | STDEV.S | STDEV.S([2,4], [8,16], [true, false]) | 6,1914 |
| STATISTICAL | STDEVA | STDEVA([2,4], [8,16], [true, false]) | 6,0139 |
| STATISTICAL | STDEVPA | STDEVPA([2,4], [8,16], [true, false]) | 5,4899 |
| STATISTICAL | STEYX | STEYX([2,3,9,1,8,7,5], [6,5,11,7,5,4,4]) | 3,3057 |
| TEXT | SUBSTITUTE | SUBSTITUTE('Quarter 1, 2011', '1', '2', 3) | Quarter 1, 2012 |
| MATH | SUBTOTAL | SUBTOTAL(9, [-5,15], [32,'Hello World!']) | 10,3200 |
| MATH | SUM | SUM(-5, 15, 32, 'Hello World!') | 42,0000 |
| MATH | SUMIF | SUMIF([2,4,8,16], '>5') | 24,0000 |
| MATH | SUMIFS | SUMIFS([2,4,8,16], [1,2,3,4], '>=2', [1,2,4,8], '<=4') | 12,0000 |
| MATH | SUMPRODUCT | SUMPRODUCT([[1,2],[3,4]], [[1,0],[0,1]]) | 5,0000 |
| MATH | SUMSQ | SUMSQ(3, 4) | 25,0000 |
| MATH | SUMX2MY2 | SUMX2MY2([1,2], [3,4]) | -20,0000 |
| MATH | SUMX2PY2 | SUMX2PY2([1,2], [3,4]) | 30,0000 |
| MATH | SUMXMY2 | SUMXMY2([1,2], [3,4]) | 8,0000 |
| LOGICAL | SWITCH | SWITCH(7, 9, 'Nine', 7, 'Seven') | Seven |
| FINANCIAL | SYD | SYD(30000, 7500, 10) | 4 090,9100 |
| TEXT | T | T('Rainfall') | Rainfall |
| STATISTICAL | T.DIST | T.DIST(60, 1, true) | 0,9947 |
| STATISTICAL | T.DIST.RT | T.DIST.RT(60, 1, true) | 0,9947 |
| STATISTICAL | T.INV | T.INV(0.9946953263673741, 1) | 60,0000 |
| STATISTICAL | T.TEST | T.TEST | |
| MATH | TAN | TAN(1) | 1,5574 |
| MATH | TANH | TANH(-2) | -0,9640 |
| FINANCIAL | TBILLEQ | TBILLEQ("3/31/2008","6/1/2008",9.14) | 9,4200 |
| FINANCIAL | TBILLPRICE | TBILLPRICE("3/31/2008","6/1/2008",9) | 98,4500 |
| FINANCIAL | TBILLYIELD | TBILLYIELD("3/31/2008","6/1/2008",98.45) | 98,1400 |
| TEXT | TEXTJOIN | TEXTJOIN("-", 1, "hello", "", " ", "world") | hello- -world |
| DATE | TIME | TIME(16, 48, 10) | 0,7001 |
| DATE | TIMEVALUE | TIMEVALUE('22-Aug-2011 6:35 AM') | 0,2743 |
| DATE | TODAY | TODAY() | Thu Feb 20 2020 23:02:55 GMT+0100 |
| TEXT | TRIM | TRIM(' First Quarter Earnings ') | First Quarter Earnings |
| STATISTICAL | TRIMMEAN | TRIMMEAN([4,5,6,7,2,3,4,5,1,2,3], 0.2) | 3,7778 |
| MATH | TRUNC | TRUNC(-8.9) | -8,0000 |
| LOGICAL | TYPE | TYPE(10) | 1,0000 |
| TEXT | UNICHAR | UNICHAR(66) | B |
| TEXT | UNICODE | UNICODE('B') | 66,0000 |
| TEXT | UPPER | UPPER('total') | TOTAL |
| TEXT | VALUE | VALUE("$1,000") | 1 000,0000 |
| STATISTICAL | VAR.A | VAR.A([2,4], [8,16], [true, false]) | 36,1667 |
| STATISTICAL | VAR.P | VAR.P([2,4], [8,16], [true, false]) | 28,7500 |
| STATISTICAL | VAR.PA | VAR.PA([2,4], [8,16], [true, false]) | 30,1389 |
| STATISTICAL | VAR.S | VAR.S([2,4], [8,16], [true, false]) | 38,3333 |
| TEXT | VLOOKUP | VLOOKUP(1, [1,2,3],1) | 1,0000 |
| LOGICAL | TRUE | TRUE() | TRUE |
| DATE | WEEKDAY | WEEKDAY('2/14/2008', 3) | 3,0000 |
| DATE | WEEKNUM | WEEKNUM('3/9/2012', 2) | 11,0000 |
| STATISTICAL | WEIBULL.DIST | WEIBULL.DIST(105, 20, 100, true) | 0,9296 |
| DATE | WORKDAY | WORKDAY('10/1/2008', 151, ['11/26/2008', '12/4/2008']) | Mon May 04 2009 00:00:00 GMT-0700 (PDT) |
| DATE | WORKDAYINTL | WORKDAYINTL('1/1/2012', 30, 17) | Sun Feb 05 2012 00:00:00 GMT-0800 (PST) |
| FINANCIAL | XIRR | XIRR( | |
| FINANCIAL | XNPV | XNPV( | |
| LOGICAL | XOR | XOR(true, false, true) | FALSE |
| DATE | YEAR | YEAR('7/5/2008') | 2 008,0000 |
| DATE | YEARFRAC | YEARFRAC('1/1/2012', '7/30/2012', 3) | 0,5781 |
| STATISTICAL | Z.TEST | Z.TEST([3,6,7,8,6,5,4,2,1,9], 4) | 0,0906 |
Commentaires
0 commentaire
Vous devez vous connecter pour laisser un commentaire.