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.