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) :
| ABS |
| ACCRINT |
| ACCRINTM |
| ACOS |
| ACOSH |
| ACOT |
| ACOTH |
| ADD |
| AGGREGATE |
| AMORDEGRC |
| AMORLINC |
| AND |
| ARABIC |
| ARGS2ARRAY |
| ASC |
| ASIN |
| ASINH |
| ATAN |
| ATAN2 |
| ATANH |
| AVEDEV |
| AVERAGE |
| AVERAGEA |
| AVERAGEIF |
| AVERAGEIFS |
| BAHTTEXT |
| BASE |
| BESSELI |
| BESSELJ |
| BESSELK |
| BESSELY |
| BETA |
| BETADIST |
| BETAINV |
| BIN2DEC |
| BIN2HEX |
| BIN2OCT |
| BINOM |
| BINOMDIST |
| BITAND |
| BITLSHIFT |
| BITOR |
| BITRSHIFT |
| BITXOR |
| CEILING |
| CEILINGMATH |
| CEILINGPRECISE |
| CELL |
| CHAR |
| CHIDIST |
| CHIDISTRT |
| CHIINV |
| CHIINVRT |
| CHISQ |
| CHITEST |
| CHOOSE |
| CLEAN |
| CODE |
| COLUMN |
| COLUMNS |
| COMBIN |
| COMBINA |
| COMPLEX |
| CONCATENATE |
| CONFIDENCE |
| CONVERT |
| CORREL |
| COS |
| COSH |
| COT |
| COTH |
| COUNT |
| COUNTA |
| COUNTBLANK |
| COUNTIF |
| COUNTIFS |
| COUNTIN |
| COUNTUNIQUE |
| COUPDAYBS |
| COUPDAYS |
| COUPDAYSNC |
| COUPNCD |
| COUPNUM |
| COUPPCD |
| COVAR |
| COVARIANCE |
| COVARIANCEP |
| COVARIANCES |
| CRITBINOM |
| CSC |
| CSCH |
| CUMIPMT |
| CUMPRINC |
| DATE |
| DATEVALUE |
| DAVERAGE |
| DAY |
| DAYS |
| DAYS360 |
| DB |
| DBCS |
| DCOUNT |
| DCOUNTA |
| DDB |
| DEC2BIN |
| DEC2HEX |
| DEC2OCT |
| DECIMAL |
| DEGREES |
| DELTA |
| DEVSQ |
| DGET |
| DISC |
| DIVIDE |
| DMAX |
| DMIN |
| DOLLAR |
| DOLLARDE |
| DOLLARFR |
| DPRODUCT |
| DSTDEV |
| DSTDEVP |
| DSUM |
| DURATION |
| DVAR |
| DVARP |
| EDATE |
| EFFECT |
| EOMONTH |
| EQ |
| ERF |
| ERFC |
| ERFCPRECISE |
| ERFPRECISE |
| ERROR |
| EVEN |
| EXACT |
| EXP |
| EXPON |
| EXPONDIST |
| FACT |
| FACTDOUBLE |
| FDIST |
| FDISTRT |
| FIND |
| FINDFIELD |
| FINV |
| FINVRT |
| FISHER |
| FISHERINV |
| FIXED |
| FLATTEN |
| FLOOR |
| FLOORMATH |
| FLOORPRECISE |
| FORECAST |
| FREQUENCY |
| FTEST |
| FV |
| FVSCHEDULE |
| GAMMA |
| GAMMADIST |
| GAMMAINV |
| GAMMALN |
| GAMMALNPRECISE |
| GAUSS |
| GCD |
| GEOMEAN |
| GESTEP |
| GROWTH |
| GTE |
| HARMEAN |
| HEX2BIN |
| HEX2DEC |
| HEX2OCT |
| HOUR |
| HTML2TEXT |
| HYPGEOM |
| HYPGEOMDIST |
| IF |
| IFERROR |
| IFNA |
| IMABS |
| IMAGINARY |
| IMARGUMENT |
| IMCONJUGATE |
| IMCOS |
| IMCOSH |
| IMCOT |
| IMCSC |
| IMCSCH |
| IMDIV |
| IMEXP |
| IMLN |
| IMLOG10 |
| IMLOG2 |
| IMPOWER |
| IMPRODUCT |
| IMREAL |
| IMSEC |
| IMSECH |
| IMSIN |
| IMSINH |
| IMSQRT |
| IMSUB |
| IMSUM |
| IMTAN |
| INFO |
| INT |
| INTERCEPT |
| INTERVAL |
| INTRATE |
| IPMT |
| IRR |
| ISBINARY |
| ISBLANK |
| ISERR |
| ISERROR |
| ISEVEN |
| ISFORMULA |
| ISLOGICAL |
| ISNA |
| ISNONTEXT |
| ISNUMBER |
| ISO |
| ISOCEILING |
| ISODD |
| ISOWEEKNUM |
| ISPMT |
| ISREF |
| ISTEXT |
| JOIN |
| js |
| KURT |
| LARGE |
| LCM |
| LEFT |
| LEN |
| LINEST |
| LN |
| LOG |
| LOG10 |
| LOGEST |
| LOGINV |
| LOGNORM |
| LOGNORMDIST |
| LOGNORMINV |
| LOWER |
| LT |
| LTE |
| MATCH |
| MAX |
| MAXA |
| MDETERM |
| MDURATION |
| MEDIAN |
| MID |
| MIN |
| MINA |
| MINUS |
| MINUTE |
| MINVERSE |
| MIRR |
| MMULT |
| MOD |
| MODE |
| MODEMULT |
| MODESNGL |
| MONTH |
| MROUND |
| MULTINOMIAL |
| MULTIPLY |
| MUNIT |
| N |
| NA |
| NE |
| NEGBINOM |
| NEGBINOMDIST |
| NETWORKDAYS |
| NETWORKDAYSINTL |
| NOMINAL |
| NORM |
| NORMDIST |
| NORMINV |
| NORMSDIST |
| NORMSINV |
| NOT |
| NOW |
| NPER |
| NPV |
| NUMBERS |
| NUMBERVALUE |
| NUMERAL |
| OCT2BIN |
| OCT2DEC |
| OCT2HEX |
| ODD |
| ODDFPRICE |
| ODDFYIELD |
| ODDLPRICE |
| ODDLYIELD |
| OR |
| PDURATION |
| PEARSON |
| PERCENTILE |
| PERCENTILEEXC |
| PERCENTILEINC |
| PERCENTRANK |
| PERCENTRANKEXC |
| PERCENTRANKINC |
| PERMUT |
| PERMUTATIONA |
| PHI |
| PI |
| PMT |
| POISSON |
| POISSONDIST |
| POW |
| POWER |
| PPMT |
| PRICE |
| PRICEDISC |
| PRICEMAT |
| PROB |
| PRODUCT |
| PRONETIC |
| PROPER |
| PV |
| QUARTILE |
| QUARTILEEXC |
| QUARTILEINC |
| QUOTIENT |
| RADIANS |
| RAND |
| RANDBETWEEN |
| RANK |
| RANKAVG |
| RANKEQ |
| RATE |
| RECEIVED |
| REFERENCE |
| REGEXEXTRACT |
| REGEXMATCH |
| REGEXREPLACE |
| REPLACE |
| REPT |
| RIGHT |
| ROMAN |
| ROUND |
| ROUNDDOWN |
| ROUNDUP |
| ROW |
| ROWS |
| RRI |
| RSQ |
| SEARCH |
| SEC |
| SECH |
| SECOND |
| SERIESSUM |
| SHEET |
| SHEETS |
| SIGN |
| SIN |
| SINH |
| SKEW |
| SKEWP |
| SLN |
| SLOPE |
| SMALL |
| SPLIT |
| SQRT |
| SQRTPI |
| STANDARDIZE |
| STDEV |
| STDEVA |
| STDEVP |
| STDEVPA |
| STDEVS |
| STEYX |
| SUBSTITUTE |
| SUBTOTAL |
| SUM |
| SUMIF |
| SUMIFS |
| SUMPRODUCT |
| SUMSQ |
| SUMX2MY2 |
| SUMX2PY2 |
| SUMXMY2 |
| SWITCH |
| SYD |
| T |
| TAN |
| TANH |
| TBILLEQ |
| TBILLPRICE |
| TBILLYIELD |
| TDIST |
| TDISTRT |
| TEXT |
| TIME |
| TIMEVALUE |
| TINV |
| TODAY |
| TRANSPOSE |
| TREND |
| TRIM |
| TRIMMEAN |
| TRUNC |
| TTEST |
| TYPE |
| UNICHAR |
| UNICODE |
| UNIQUE |
| UPPER |
| VALUE |
| VAR |
| VARA |
| VARP |
| VARPA |
| VARS |
| VDB |
| WEEKDAY |
| WEEKNUM |
| WEIBULL |
| WEIBULLDIST |
| WORKDAY |
| WORKDAYINTL |
| XIRR |
| XNPV |
| XOR |
| YEAR |
| YEARFRAC |
| YIELD |
| YIELDDISC |
| YIELDMAT |
| FALSE |
| TRUE |
Commentaires
0 commentaire
Vous devez vous connecter pour laisser un commentaire.