Fonctions Excel prises en charge
Les API Aspose.Cells prennent en charge la plupart des fonctions standard et la formule intégrée d’Excel. Ci-dessous, vous pouvez trouver toutes les fonctions prises en charge par ordre alphabétique.
Aspose.Cells' Le moteur de calcul de formules vous permet de définir, lire et calculer les résultats des formules et fonctions suivantes.
UN*
| Fonction |
Résumé |
| ABS |
|
| ACCRINT |
|
| ACCRINTM |
|
| ACOS |
|
| ACOSH |
|
| ADDRESS |
|
| AGGREGATE |
|
| AMORDEGRC |
|
| AMORLINC |
|
| ANCHORARRAY |
|
| AND |
|
| AREAS |
|
| ASC |
|
| ASIN |
|
| ASINH |
|
| ATAN |
|
| ATAN2 |
|
| ATANH |
|
| AVEDEV |
|
| AVERAGE |
|
| AVERAGEA |
|
| AVERAGEIF |
|
| AVERAGEIFS |
|
B*
| Fonction |
Résumé |
| BESSELI |
|
| BESSELJ |
|
| BESSELK |
|
| BESSELY |
|
| BETADIST |
|
| BETA.DIST |
|
| BETAINV |
|
| BÊTA.INV |
|
| BIN2DEC |
|
| BIN2HEX |
|
| BIN2OCT |
|
| BINOMDIST |
|
| BINOM.DIST |
|
| BITAND |
|
| BITLSHIFT |
|
| BITOR |
|
| BITRSHIFT |
|
| BITXOR |
|
C*
| Fonction |
Résumé |
| CEILING |
|
| PLAFOND.MATH |
|
| PLAFOND.PRECISE |
|
| CELL |
|
| CHAR |
|
| CHIDIST |
|
| CHIINV |
|
| CHITEST |
|
| CHISQ.DIST |
|
| CHISQ.DIST.RT |
|
| CHISQ.INV.RT |
|
| CHISQ.TEST |
|
| CHOOSE |
|
| CHOOSECOLS |
|
| CHOOSEROWS |
|
| CLEAN |
|
| CODE |
|
| COLUMN |
|
| COLUMNS |
|
| COMBIN |
|
| COMPLEX |
|
| CONCAT |
|
| CONCATENATE |
|
| CONFIDENCE |
|
| CONFIANCE.NORME |
|
| CONVERT |
|
| CORREL |
|
| COS |
|
| COSH |
|
| COUNT |
|
| COUNTA |
|
| COUNTBLANK |
|
| COUNTIF |
|
| COUNTIFS |
|
| COUPDAYBS |
|
| COUPDAYS |
|
| COUPDAYSNC |
|
| COUPNCD |
|
| COUPNUM |
|
| COUPPCD |
|
| COVAR |
|
| COVARIANCE.P |
|
| COVARIANCE.S |
|
| CRITBINOM |
|
| CUMIPMT |
|
| CUMPRINC |
|
D*
| Fonction |
Résumé |
| DATE |
|
| DATEDIF |
|
| DATEVALUE |
|
| DAVERAGE |
|
| DAY |
|
| DAYS |
|
| DAYS360 |
|
| DB |
|
| DCOUNT |
|
| DCOUNTA |
|
| DDB |
|
| DEC2BIN |
|
| DEC2HEX |
|
| DEC2OCT |
|
| DEGREES |
|
| DELTA |
|
| DEVSQ |
|
| DGET |
|
| DISC |
|
| DMAX |
|
| DMIN |
|
| DOLLAR |
|
| DOLLARDE |
|
| DOLLARFR |
|
| DPRODUCT |
|
| DSTDEV |
|
| DSTDEVP |
|
| DSUM |
|
| DURATION |
|
| DVAR |
|
| DVARP |
|
E*
| Fonction |
Résumé |
| EDATE |
|
| EFFECT |
|
| ENCODEURL |
|
| EOMONTH |
|
| ERF |
|
| ERFC |
|
| ERREUR.TYPE |
|
| EVEN |
|
| EXACT |
|
| EXP |
|
| EXPONDIST |
|
F*
| Fonction |
Résumé |
| FACT |
|
| FACTDOUBLE |
|
| FALSE |
|
| F.DIST |
|
| FDIST |
|
| F.DIST.RT |
|
| FILTER |
|
| FIND |
|
| FINDB |
|
| F.INV.RT |
|
| FINV |
|
| FISHER |
|
| FISHERINV |
|
| FIXED |
|
| FLOOR |
|
| ÉTAGE.MATH |
|
| FORECAST |
|
| PRÉVISION.LINÉAIRE |
|
| FORMULATEXT |
|
| FREQUENCY |
|
| FV |
|
| FVSCHEDULE |
|
G*
| Fonction |
Résumé |
| GAMMA.DIST |
|
| GAMMADIST |
|
| GAMMA.INV |
|
| GAMMAINV |
|
| GAMMALN |
|
| GCD |
|
| GEOMEAN |
|
| GESTEP |
|
| GETPIVOTDATA |
|
| GROWTH |
|
H*
| Fonction |
Résumé |
| HARMEAN |
|
| HEX2BIN |
|
| HEX2DEC |
|
| HEX2OCT |
|
| HLOOKUP |
|
| HOUR |
|
| HSTACK |
|
| HYPERLINK |
|
| HYPGEOM.DIST |
|
| HYPGEOMDIST |
|
JE*
| Fonction |
Résumé |
| IF |
|
| IFERROR |
|
| IFNA |
|
| IFS |
|
| IMABS |
|
| IMAGINARY |
|
| IMARGUMENT |
|
| IMCONJUGATE |
|
| IMCOS |
|
| IMDIV |
|
| IMEXP |
|
| IMLN |
|
| IMLOG10 |
|
| IMLOG2 |
|
| IMPOWER |
|
| IMPRODUCT |
|
| IMREAL |
|
| IMSIN |
|
| IMSQRT |
|
| IMSUB |
|
| IMSUM |
|
| INDEX |
|
| INDIRECT |
|
| INT |
|
| INTERCEPT |
|
| INTRATE |
|
| IPMT |
|
| IRR |
|
| ISBLANK |
|
| ISERR |
|
| ISERROR |
|
| ISEVEN |
|
| ISFORMULA |
|
| ISLOGICAL |
|
| ISNA |
|
| ISNONTEXT |
|
| ISNUMBER |
|
| ISODD |
|
| ISREF |
|
| ISTEXT |
|
| ISOWEEKNUM |
|
| ISPMT |
|
K*
L*
| Fonction |
Résumé |
| LAMBDA |
|
| LARGE |
|
| LCM |
|
| LEFT |
|
| LEFTB |
|
| LEN |
|
| LENB |
|
| LET |
|
| LINEST |
|
| LN |
|
| LOG |
|
| LOG10 |
|
| LOGEST |
|
| LOGINV |
|
| LOGNORM.DIST |
|
| LOGNORM.INV |
|
| LOGNORMDIST |
|
| LOOKUP |
|
| LOWER |
|
M*
| Fonction |
Résumé |
| MAKEARRAY |
|
| MAP |
|
| MATCH |
|
| MAX |
|
| MAXA |
|
| MAXIFS |
|
| MDETERM |
|
| MDURATION |
|
| MEDIAN |
|
| MID |
|
| MIDB |
|
| MIN |
|
| MINIFS |
|
| MINA |
|
| MINUTE |
|
| MINVERSE |
|
| MIRR |
|
| MMULT |
|
| MOD |
|
| MODE |
|
| MODE.MULT |
|
| MODE.SNGL |
|
| MONTH |
|
| MROUND |
|
| MULTINOMIAL |
|
N*
| Fonction |
Résumé |
| N |
|
| NA |
|
| NEGBINOM.DIST |
|
| NEGBINOMDIST |
|
| NETWORKDAYS |
|
| NETWORKDAYS.INTL |
|
| NOMINAL |
|
| DIST.NORME |
|
| NORMDIST |
|
| NORMINV |
|
| NORME.INV |
|
| NORM.S.DIST |
|
| NORMSDIST |
|
| NORM.S.INV |
|
| NORMSINV |
|
| NOT |
|
| NOW |
|
| NPER |
|
| NPV |
|
| NUMBERVALUE |
|
O*
| Fonction |
Résumé |
| OCT2BIN |
|
| OCT2DEC |
|
| OCT2HEX |
|
| ODD |
|
| ODDFPRICE |
|
| ODDFYIELD |
|
| ODDLPRICE |
|
| ODDLYIELD |
|
| OFFSET |
|
| OR |
|
P*
| Fonction |
Résumé |
| PEARSON |
|
| PERCENTILE.EXC |
|
| PERCENTILE.INC |
|
| PERCENTILE |
|
| POURCENTAGE.EXC |
|
| PERCENTRANK.INC |
|
| PERCENTRANK |
|
| PERMUT |
|
| PI |
|
| PMT |
|
| POISSON.DIST |
|
| POISSON |
|
| POWER |
|
| PPMT |
|
| PRICE |
|
| PRICEDISC |
|
| PRICEMAT |
|
| PROB |
|
| PRODUCT |
|
| PROPER |
|
| PV |
|
Q*
| Fonction |
Résumé |
| QUARTILE |
|
| QUARTILE.EXC |
|
| QUARTILE.INC |
|
| QUOTIENT |
|
R*
| Fonction |
Résumé |
| RADIANS |
|
| RAND |
|
| RANDARRAY |
|
| RANDBETWEEN |
|
| RANG.MOYENNE |
|
| RANG.EQ |
|
| RANK |
|
| RATE |
|
| RECEIVED |
|
| REPLACE |
|
| REPLACEB |
|
| REPT |
|
| RIGHT |
|
| RIGHTB |
|
| ROMAN |
|
| ROUND |
|
| ROUNDDOWN |
|
| ROUNDUP |
|
| ROW |
|
| ROWS |
|
| RSQ |
|
S*
| Fonction |
Résumé |
| SCAN |
|
| SEARCH |
|
| SEARCHB |
|
| SECOND |
|
| SEQUENCE |
|
| SERIESSUM |
|
| SHEET |
|
| SHEETS |
|
| SIGN |
|
| SIN |
|
| SINH |
|
| SINGLE |
|
| SKEW |
|
| SLN |
|
| SLOPE |
|
| SMALL |
|
| SORT |
|
| SORTBY |
|
| SQRT |
|
| SQRTPI |
|
| STANDARDIZE |
|
| STDEV |
|
| STDEV.P |
|
| STDEV.S |
|
| STDEVA |
|
| STDEVP |
|
| STDEVPA |
|
| STEYX |
|
| SUBSTITUTE |
|
| SUBTOTAL |
|
| SUM |
|
| SUMIF |
|
| SUMIFS |
|
| SUMPRODUCT |
|
| SUMSQ |
|
| SUMX2MY2 |
|
| SUMX2PY2 |
|
| SUMXMY2 |
|
| SWITCH |
|
| SYD |
|
T*
| Fonction |
Résumé |
| T |
|
| TAN |
|
| TANH |
|
| TBILLEQ |
|
| TBILLPRICE |
|
| TBILLYIELD |
|
| T.DIST.2T |
|
| T.DIST.RT |
|
| TDIST |
|
| TEXT |
|
| TEXTAFTER |
|
| TEXTBEFORE |
|
| TEXTJOIN |
|
| TEXTSPLIT |
|
| TIME |
|
| TIMEVALUE |
|
| T.INV.2T |
|
| TINV |
|
| TOCOL |
|
| TODAY |
|
| TOROW |
|
| TRANSPOSE |
|
| TREND |
|
| TRIM |
|
| TRIMMEAN |
|
| TRUE |
|
| TRUNC |
|
| T.TEST |
|
| TTEST |
|
| TYPE |
|
U*
| Fonction |
Résumé |
| UNICHAR |
|
| UNICODE |
|
| UNIQUE |
|
| UPPER |
|
| USDOLLAR |
|
V*
| Fonction |
Résumé |
| VALUE |
|
| VAR |
|
| VAR.P |
|
| VAR.S |
|
| VARA |
|
| VARP |
|
| VARPA |
|
| VDB |
|
| VLOOKUP |
|
| VSTACK |
|
W*
| Fonction |
Résumé |
| WEEKDAY |
|
| WEEKNUM |
|
| WEIBULL |
|
| WEIBULL.DIST |
|
| WORKDAY |
|
| WORKDAY.INTL |
|
X*
| Fonction |
Résumé |
| XIRR |
|
| XLOOKUP |
|
| XNPV |
|
O*
| Fonction |
Résumé |
| YEAR |
|
| YEARFRAC |
|
| YIELD |
|
| YIELDDISC |
|
| YIELDMAT |
|
Z*
| Fonction |
Résumé |
| Z.TEST |
|
| ZTEST |
|
