Unterstützte Excel-Funktionen

A

ABS, ACCRINT, ACCRINTM, ACOS, ACOSH, ADDRESS, AMORDEGRC, AMORLINC, AND, AREAS, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF

B

BESSELI, BESSELJ, BESSELK, BESSELY, BETADIST, BETAINV, BIN2DEC, BIN2HEX, BIN2OCT, BINOMDIST

C

CEILING, CHAR, CHIDIST, CHIINV, CHITEST, CHOOSE, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, COVAR, CRITBINOM, CUMIPMT, CUMPRINC

D

DATE, DATEDIF, DATEVALUE, DAY, DAYS360, DAVERAGE, 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

EDATE, EFFECT, EOMONTH, ERF, ERFC, ERROR.TYPE, EVEN, EXACT, EXP, EXPONDIST

F

F.DIST, F.DIST.RT, F.INV.RT, FACT, FACTDOUBLE, FDIST, FIND, FINDB, FINV, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FORMULATEXT, FREQUENCY, FV, FVSCHEDULE, FALSE

G

GAMMADIST, GAMMAINV, GAMMALN, GCD, GEOMEAN, GESTEP, GROWTH

H

HARMEAN, HLOOKUP, HOUR, HYPGEOMDIST, HYPERLINK

I

IF, IFERROR, IMABS, IMAGINARY , IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM, INDEX, INDIRECT, INT, INTERCEPT, INTRATE, IPMT, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISPMT, ISREF, ISTEXT

K

KURT

L

LARGE, LCM, LEFT, LEFTB, LEN, LENB, LINEST, LN, LOG, LOG10, LOGEST, LOGINV, LOGNORMDIST, LOOKUP, LOWER

M

MATCH, MAX, MAXA, MDETERM, MDURATION, MEDIAN, MID, MIDB, MIN, MINA, MINUTE, MINVERSE, MIRR, MMULT, MOD, MODE, MONTH, MROUND, MULTINOMIAL

N

N, NA, NEGBINOMDIST, NETWORKDAYS, NOMINAL, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV

O

OCT2BIN, OCT2DEC, OCT2HEX, ODD, ODDFPRICE, ODDLPRICE, ODDLYIELD, OFFSET, OR

P

PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PI, PMT, POISSON, POWER, PPMT, PRICE, PRICEDISC, PRICEMAT, PROB, PRODUCT, PROPER, PV

Q

QUARTILE, QUOTIENT

R

RADIANS, RAND, RANDBETWEEN, RANK, RATE, RECEIVED, REPLACE, REPLACEB, REPT, RIGHT, RIGHTB, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ

S

SEARCH, SEARCHB, SECOND, SERIESSUM, SIGN, SIN, SINH, SKEW, SLN, SLOPE, SMALL, SQRT, SQRTPI, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD

T

T, TAN, TANH, TBILLEQ, TBILLPRICE, TBILLYIELD, TDIST, TEXT, TIME, TIMEVALUE, TINV, TODAY, TREND, TRIM, TRIMMEAN, TRUE, TRUNC, TTEST, TYPE

U

UPPER, USDOLLAR

V

VALUE, VAR, VARA, VARP, VARPA, VDB, VLOOKUP

W

WEEKDAY, WEEKNUM, WEIBULL, WORKDAY

X

XIRR, XNPV

Y

YEAR, YEARFRAC, YIELD, YIELDDISC, YIELDMAT

Z

ZTEST