وظائف Excel المدعومة
تدعم واجهات برمجة التطبيقات Aspose.Cells معظم الوظائف القياسية وصيغة Excel المضمنة. أدناه، يمكنك العثور على جميع الوظائف المدعومة بالترتيب الأبجدي.
Aspose.Cells يتيح لك محرك حساب الصيغة تعيين وقراءة وحساب نتائج الصيغ والوظائف التالية.
أ*
وظيفة |
ملخص |
ABS |
|
ACCRINT |
|
ACCRINTM |
|
ACOS |
|
ACOSH |
|
ADDRESS |
|
AGGREGATE |
|
AMORDEGRC |
|
AMORLINC |
|
ANCHORARRAY |
|
AND |
|
AREAS |
|
ASC |
|
ASIN |
|
ASINH |
|
ATAN |
|
ATAN2 |
|
ATANH |
|
AVEDEV |
|
AVERAGE |
|
AVERAGEA |
|
AVERAGEIF |
|
AVERAGEIFS |
|
ب*
وظيفة |
ملخص |
BESSELI |
|
BESSELJ |
|
BESSELK |
|
BESSELY |
|
BETADIST |
|
BETA.DIST |
|
BETAINV |
|
BETA.INV |
|
BIN2DEC |
|
BIN2HEX |
|
BIN2OCT |
|
BINOMDIST |
|
BINOM.DIST |
|
BITAND |
|
BITLSHIFT |
|
BITOR |
|
BITRSHIFT |
|
BITXOR |
|
ج*
وظيفة |
ملخص |
CEILING |
|
CEILING.MATH |
|
السقف.دقيق |
|
CELL |
|
CHAR |
|
CHIDIST |
|
CHIINV |
|
CHITEST |
|
CHISQ.DIST |
|
CHISQ.DIST.RT |
|
CHISQ.INV.RT |
|
اختبار CHISQ |
|
CHOOSE |
|
CHOOSECOLS |
|
CHOOSEROWS |
|
CLEAN |
|
CODE |
|
COLUMN |
|
COLUMNS |
|
COMBIN |
|
COMPLEX |
|
CONCAT |
|
CONCATENATE |
|
CONFIDENCE |
|
الثقة.المعيار |
|
CONVERT |
|
CORREL |
|
COS |
|
COSH |
|
COUNT |
|
COUNTA |
|
COUNTBLANK |
|
COUNTIF |
|
COUNTIFS |
|
COUPDAYBS |
|
COUPDAYS |
|
COUPDAYSNC |
|
COUPNCD |
|
COUPNUM |
|
COUPPCD |
|
COVAR |
|
التباين.P |
|
التباين.S |
|
CRITBINOM |
|
CUMIPMT |
|
CUMPRINC |
|
د*
وظيفة |
ملخص |
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 |
|
ه*
وظيفة |
ملخص |
EDATE |
|
EFFECT |
|
ENCODEURL |
|
EOMONTH |
|
ERF |
|
ERFC |
|
خطأ.نوع |
|
EVEN |
|
EXACT |
|
EXP |
|
EXPONDIST |
|
F*
وظيفة |
ملخص |
FACT |
|
FACTDOUBLE |
|
FALSE |
|
F.DIST |
|
FDIST |
|
F.DIST.RT |
|
FILTER |
|
FIND |
|
FINDB |
|
F.INV.RT |
|
FINV |
|
FISHER |
|
FISHERINV |
|
FIXED |
|
FLOOR |
|
FLOR.MATH |
|
FORECAST |
|
توقعات.خطية |
|
FORMULATEXT |
|
FREQUENCY |
|
FV |
|
FVSCHEDULE |
|
ز*
وظيفة |
ملخص |
GAMMA.DIST |
|
GAMMADIST |
|
GAMMA.INV |
|
GAMMAINV |
|
GAMMALN |
|
GCD |
|
GEOMEAN |
|
GESTEP |
|
GETPIVOTDATA |
|
GROWTH |
|
ح*
وظيفة |
ملخص |
HARMEAN |
|
HEX2BIN |
|
HEX2DEC |
|
HEX2OCT |
|
HLOOKUP |
|
HOUR |
|
HSTACK |
|
HYPERLINK |
|
HYPGEOM.DIST |
|
HYPGEOMDIST |
|
أنا*
وظيفة |
ملخص |
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 |
|
ك*
ل*
وظيفة |
ملخص |
LAMBDA |
|
LARGE |
|
LCM |
|
LEFT |
|
LEFTB |
|
LEN |
|
LENB |
|
LET |
|
LINEST |
|
LN |
|
LOG |
|
LOG10 |
|
LOGEST |
|
LOGINV |
|
LOGNORM.DIST |
|
LOGNORM.INV |
|
LOGNORMDIST |
|
LOOKUP |
|
LOWER |
|
م*
وظيفة |
ملخص |
MAKEARRAY |
|
MAP |
|
MATCH |
|
MAX |
|
MAXA |
|
MAXIFS |
|
MDETERM |
|
MDURATION |
|
MEDIAN |
|
MID |
|
MIDB |
|
MIN |
|
MINIFS |
|
MINA |
|
MINUTE |
|
MINVERSE |
|
MIRR |
|
MMULT |
|
MOD |
|
MODE |
|
الوضع.متعدد |
|
MODE.SNGL |
|
MONTH |
|
MROUND |
|
MULTINOMIAL |
|
ن*
وظيفة |
ملخص |
N |
|
NA |
|
NEGBINOM.DIST |
|
NEGBINOMDIST |
|
NETWORKDAYS |
|
NETWORKDAYS.INTL |
|
NOMINAL |
|
NORM.DIST |
|
NORMDIST |
|
NORMINV |
|
NORM.INV |
|
NORM.SDIST |
|
NORMSDIST |
|
NORM.S.INV |
|
NORMSINV |
|
NOT |
|
NOW |
|
NPER |
|
NPV |
|
NUMBERVALUE |
|
يا*
وظيفة |
ملخص |
OCT2BIN |
|
OCT2DEC |
|
OCT2HEX |
|
ODD |
|
ODDFPRICE |
|
ODDFYIELD |
|
ODDLPRICE |
|
ODDLYIELD |
|
OFFSET |
|
OR |
|
ف*
وظيفة |
ملخص |
PEARSON |
|
المئوي.EXC |
|
PERCENTILE.INC |
|
PERCENTILE |
|
PERCENTRANK.EXC |
|
PERCENTRANK.INC |
|
PERCENTRANK |
|
PERMUT |
|
PI |
|
PMT |
|
POISSON.DIST |
|
POISSON |
|
POWER |
|
PPMT |
|
PRICE |
|
PRICEDISC |
|
PRICEMAT |
|
PROB |
|
PRODUCT |
|
PROPER |
|
PV |
|
س*
وظيفة |
ملخص |
QUARTILE |
|
QUARTILE.EXC |
|
QUARTILE.INC |
|
QUOTIENT |
|
ص*
وظيفة |
ملخص |
RADIANS |
|
RAND |
|
RANDARRAY |
|
RANDBETWEEN |
|
متوسط |
|
RANK.EQ |
|
RANK |
|
RATE |
|
RECEIVED |
|
REPLACE |
|
REPLACEB |
|
REPT |
|
RIGHT |
|
RIGHTB |
|
ROMAN |
|
ROUND |
|
ROUNDDOWN |
|
ROUNDUP |
|
ROW |
|
ROWS |
|
RSQ |
|
س*
وظيفة |
ملخص |
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 |
|
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 |
|
اختبار تي |
|
TTEST |
|
TYPE |
|
ش*
وظيفة |
ملخص |
UNICHAR |
|
UNICODE |
|
UNIQUE |
|
UPPER |
|
USDOLLAR |
|
الخامس*
وظيفة |
ملخص |
VALUE |
|
VAR |
|
VAR.P |
|
حكم الفيديو المساعد |
|
VARA |
|
VARP |
|
VARPA |
|
VDB |
|
VLOOKUP |
|
VSTACK |
|
ث*
وظيفة |
ملخص |
WEEKDAY |
|
WEEKNUM |
|
WEIBULL |
|
WEIBULL.DIST |
|
WORKDAY |
|
يوم العمل.INTL |
|
X*
وظيفة |
ملخص |
XIRR |
|
XLOOKUP |
|
XNPV |
|
ص*
وظيفة |
ملخص |
YEAR |
|
YEARFRAC |
|
YIELD |
|
YIELDDISC |
|
YIELDMAT |
|
ض*
وظيفة |
ملخص |
اختبار Z |
|
ZTEST |
|