Auf dieser Seite werden die Formelfunktionen aufgelistet, die von
- sowohl Workiva als auch Excel
- sowohl Workiva als auch Google Sheets
- Nur Workiva
- Nur Excel
- Nur Google Sheets
- Workiva-Ketten (für Datenvorbereitung)
Hinweis: Workiva Platform Arbeitsblätter und Tabellen unterstützen keine benannten Bereiche, Makros oder Arrays. Außerdem unterstützen sie nur englischsprachige Funktionen. Sie unterstützen keine Funktionen in einer anderen Sprache.
| Nur Workiva | Nur Google | Neu in Q1 2026 |
† Kann mit der Funktion CHILDREFS verwendet werden. **CHILDREFS muss mit einer anderen Funktion verwendet werden.
| Workiva und Excel | Excel (nicht Workiva) | Datenvorbereitung/ Workiva | Datenvorbereitung und Excel (nicht Workiva) | Google Sheets (nicht Workiva) | Google und Workiva | Workiva (nicht Google) |
|---|---|---|---|---|---|---|
| ABS | ACCRINT | ABS | ACOS | ACCRINT | ABS | CHOOSECOLS |
| AND† | ACCRINTM | AND | ACOSH | ACCRINTM | UND | CHOOSEROWS |
| AVERAGE† | ACOS | AVERAGE | ADRESSE | ACOS | Durchschnitt | CODE |
| AVERAGEA† | ACOSH | AVERAGEA | BEREICHE | ACOSH | AVERAGEA | COLUMNS |
| AVERAGEIF | ACOT | CHAR | ASIN | ACOT | AVERAGEIF | DROP |
| AVERAGEIFS | ACOTH | CHOOSE | ASINH | ACOTH | AVERAGEIFS | HSTACK |
| CELL | ADRESSE | CODE | ATAN | ADRESSE | Zelle | MAXIFS |
| CHAR | AGGREGATE | COLUMNS | ATAN2 | KI | CHAR | MINIFS |
| CHILDREFS** | AMORDEGRC | CONCATENATE | ATANH | AMORLINC | CHOOSE | MMULT |
| CHOOSE† | AMORLINC | COUNT | AVEDEV | ARRAYFORMULA | SPALTEN | PERZENTIL |
| CHOOSECOLS | ARABISCH | COUNTA | DECKEN | ARRAYFORMULA (Array-Operationen) | CONCAT | PERZENTIL.EXC |
| CHOOSEROWS | BEREICHE | COUNTBLANK | CLEAN | ASIN | CONCATENATE | PERZENTIL.INC |
| CODE | ARRAYTOTEXT | COUNTIF | KOLUMNE | ASINH | ZÄHLEN | QUARTILE |
| COLUMNS | ASC | DATE | COMBIN | ATAN | COUNTA | QUARTILE.EXC |
| CONCAT | ASIN | DATEVALUE | CORREL | ATAN2 | COUNTBLANK | QUARTILE.INC |
| CONCATENATE† | ASINH | DAY | COS | ATANH | COUNTIF | RANK.AVG |
| CONCATENATEIF | ATAN | DAYS360 | COSH | AVEDEV | COUNTIFS | RANK.EQ |
| COUNT† | ATAN2 | EXP | COVAR | BASIS | DATUM | STDEV.P |
| COUNTA† | ATANH | FIND | DAVERAGE | BIN2DEC | DatumVALUE | STDEV.S |
| COUNTBLANK† | AVEDEV | FV | DCOUNT | BIN2HEX | DAY | STDEVPA |
| COUNTIF | AVERAGEIF | HLOOKUP | DCOUNTA | BIN2OCT | DAYS | SUMPRODUCT |
| COUNTIFS | BAHTTEXT | IF | DEGREES | BITAND | DAYS360 | TAKE |
| DATE | BASIS | INDEX | DEVSQ | BITLSHIFT | EDatum | TEXTJOIN |
| DATEVALUE | BESSELI | IRR | DGET | BITOR | EOMONTH | TEXTSPLIT |
| DAY | BESSELJ | ISBLANK | DMAX | BITRSHIFT | EXP | TRANSPOSE |
| DAYS | BESSELK | ISERROR | DMIN | BITXOR | FILTER | TRUNC |
| DAYS360 | BESSELY | ISNA | DOLLAR | DECKEN | FIND | UNICHAR |
| DROP | BETA.DIST | ISNUMBER | DPRODUCT | CEILING.MATH | FV | UNICODE |
| EDATE | BETA.INV | LARGE | DSTDEV | DECKE.GENAU | HLOOKUP | VSTACK |
| EOMONTH | BETADIST | LEFT | DSTDEVP | CHIDIST | IF | XMATCH |
| EXP | BETAINV | LEN | DSUM | CHIINV | IFERROR | |
| FIND | BIN2DEC | LN | DVAR | CHITEST | IFNA | |
| FILTER | BIN2HEX | LOWER | DVARP | CLEAN | IFS | |
| FV | BIN2OCT | MATCH | ERROR.TYP | KOLUMNE | INDEX | |
| HLOOKUP | BINOM.DIST | MAX | EVEN | COMBIN | INT | |
| HSTACK | BINOM.DIST.BEREICH | MAXA | EXAKT | COMBINA | IRR (Internal Rate of Return) | |
| IF† | BINOM.INV | MEDIAN | FACT | KOMPLEX | ISBLANK | |
| IFERROR | BINOMDIST | MID | FIXED | CONCAT | ISERROR | |
| IFNA | BITAND | MIN | FLOOR | ZUVERLÄSSIGKEIT | ISNA | |
| IFS† | BITLSHIFT | MINA | FORECAST | CORREL | ISNUMMER | |
| INDEX | BITOR | MOD | FREQUENZ | COS | LARGE | |
| INT | BITRSHIFT | MONTH | GEOMEAN | COSH | Links | |
| IRR | BITXOR | NOT | STUNDE | COT | LEN | |
| ISBLANK | BYCOL | NPV | HYPERLINK | COTH | LN | |
| ISERROR | BYROW | OR | INDIRECT | COUNTUNIQUE | LOWER | |
| ISNA | DECKEN | PERCENTILE | INTERCEPT | COUPDAYBS | MATCH | |
| ISNUMBER | CEILING.MATH | PMT | IPMT | COUPDAYS | MAX | |
| LARGE† | DECKE.GENAU | POWER | ISERR | COUPDAYSNC | MAXA | |
| LEFT | CHIDIST | PRODUCT | ISLOGISCH | COUPNCD | MEDIAN | |
| LEN | CHIINV | PROPER | ISNONTEXT | COUPNUM | MID | |
| LN | CHISQ.DIST | PV | ISREF | COUPPCD | MIN | |
| LOWER | CHISQ.DIST.RT | RANK | ISTEXT | COVAR | MINA | |
| MATCH | CHISQ.INV | REPT | LOG | CSC | MOD | |
| MAX† | CHISQ.INV.RT | RIGHT | LOG10 | CSCH | Monat | |
| MAXA† | CHISQ.TEST | ROUND | LOOKUP | CUMIPMT | MROUND | |
| MAXIFS | CHITEST | ROUNDDOWN | MDETERM | CUMPRINC | N | |
| MEDIAN† | CLEAN | ROUNDUP | MINUTE | DATEDIF | NETWORKDAYS | |
| MID | KOLUMNE | ROWS | MINVERSE | DB | NETWORKDAYS.INTL | |
| MIN† | SPALTEN | SEARCH | MIRR | DDB | NICHT | |
| MINA† | COMBIN | SIGN | MODUS | DEC2BIN | Kapitalwert | |
| MINIFS | COMBINA | SMALL | n. z. | DEC2HEX | ODER | |
| MMULT | COMPLEX | SQRT | NORMDIST | DEC2OCT | PMT | |
| MOD | ZUVERLÄSSIGKEIT | STDEV | NORMINV | DECIMAL | POWER | |
| MONTH | VERTRAUEN.NORM | STDEVA | NORMSDIST | DEGREES | PRODUKT | |
| MROUND | ZUVERLÄSSIGKEIT.T | SUBSTITUTE | NORMSINV | DELTA | PROPER | |
| N | CONVERT | SUBTOTAL | HEUTE | SPRACHE ERKENNEN | PV | |
| NETWORKDAYS | COPILOT | SUM | NPER | DISC | RANK | |
| NETWORKDAYS.INTL | CORREL | SUMIF | ODD | DOLLARDE | REPT | |
| NOT | COS | SUMPRODUCT | OFFSET | DOLLARFR | RECHTS | |
| NPV† | COSH | TEXT | PEARSON | DAUER | RUND | |
| OR† | COT | TRANSPOSE | PERCENTRANK | EFFEKT | ROUNDDOWN | |
| PERCENTILE | COTH | TRIM | PI | EPOCHTODATE | ROUNDUP | |
| PERCENTILE.EXC | COUPDAYBS | TRUNC | POISSON | ERF | REIHEN | |
| PERCENTILE.INC | COUPDAYS | UPPER | PPMT | ERF.PRECISE | SUCHE | |
| PMT | COUPDAYSNC | VALUE | RADIANS | ERFC | SEQUENCE | |
| POWER | COUPNCD | VLOOKUP | RAND | ERFC.PRECISE | SIGN | |
| PRODUCT† | COUPNUM | WEEKDAY | REPLACE | ERROR.TYP | SMALL | |
| PROPER | COUPPCD | YEAR | ROMAN | EVEN | SORT | |
| PV | COVAR | ROW | EXAKT | SQRT | ||
| QUARTILE | COVARIANCE.P | SECOND | FACT | STDEV | ||
| QUARTILE.EXC | COVARIANCE.S | SIN | FACTDOUBLE | STDEVA | ||
| QUARTILE.INC | CRITBINOM | SINH | FISHER | SUBSTITUTE | ||
| RANK† | CSC | SLOPE | FISCHERINV | ZWISCHENSUMME | ||
| RANK.AVG† | CSCH | STANDARDIIEREN | FLOOR | SUMME | ||
| RANK.EQ† | CUBEKPIMEMBER | STDEVP | FLOOR.MATH | SUMIF | ||
| REPT | CUBEMEMBER | STDEVPA | FLOOR.PRECISE | SUMIFS | ||
| RIGHT | CUBEMEMBERPROPERTY | SUMSQ | FORMELTEXT | TEXT | ||
| ROUND | CUBERANKEDMEMBER | SUMX2MY2 | FTEST | TRIM | ||
| ROUNDDOWN | CUBESET | SUMX2PY2 | FVSCHEDULE | EINZIGARTIG | ||
| ROUNDUP | CUBESETCOUNT | SUMXMY2 | GAMMA | UPPER | ||
| ROWS | CUBEVALUE | T | GAMMADIST | WERT | ||
| SEARCH | CUMIPMT | TAN | GAMMAINV | VLOOKUP | ||
| SEQUENCE | CUMPRINC | TANH | GAMMALN | WEEKDAY | ||
| SIGN | DATEDIF | TDIST | GAMMALN.PRÄZISE | ARBEITSTAG | ||
| SMALL† | DAVERAGE | ZEIT | GCD | ARBEITSTAG.INTL | ||
| SORT | DB | ZEITWERT | GESTEP | XIRR | ||
| SQRT | DBCS | HEUTE | GETPIVOTDATA | XLOOKUP | ||
| STDEV† | DCOUNT | TREND | GOOGLEFINANCE | XNPV | ||
| STDEV.P† | DCOUNTA | VAR | GOOGLETRANSLATE | Jahr | ||
| STDEV.S† | DDB | VARA | WACHSTUM | JAHRFRAC | ||
| STDEVA† | DEC2BIN | VARP | HEX2BIN | |||
| STDEVPA† | DEC2HEX | VARPA | HEX2DEC | |||
| SUBSTITUTE | DEC2OCT | HEX2OCT | ||||
| SUBTOTAL | DECIMAL | STUNDE | ||||
| SUM† | DEGREES | IMABS | ||||
| SUMIF | DELTA | IMAGE | ||||
| SUMIFS | DEVSQ | IMAGINÄR | ||||
| SUMPRODUCT | DGET | IMARGUMENT | ||||
| TAKE | DISC | IMCONJUGATE | ||||
| TEXT | DMAX | IMCOS | ||||
| TEXTJOIN† | DMIN | IMCOSH | ||||
| TEXTSPLIT | DOLLAR | IMCOT | ||||
| TOCOL | DOLLARDE | IMCOTH | ||||
| TOROW | DOLLARFR | IMCSC | ||||
| TRANSPOSE | DPRODUCT | IMCSCH | ||||
| TRIM | DSTDEV | IMDIV | ||||
| TRUNC | DSTDEVP | IMEXP | ||||
| UNICHAR | DSUM | IMLN | ||||
| UNICODE | DAUER | IMLOG | ||||
| UNIQUE | DVAR | IMLOG10 | ||||
| UPPER | DVARP | IMLOG2 | ||||
| VALUE | EFFEKT | IMPOWER | ||||
| VLOOKUP | ENCODEURL | IMPRODUKT | ||||
| VSTACK | ERF | IMREAL | ||||
| WEEKDAY | ERF.PRECISE | IMSEC | ||||
| WORKDAY | ERFC | IMSECH | ||||
| WORKDAY.INTL | ERFC.PRECISE | IMSIN | ||||
| XLOOKUP | ERROR.TYP | IMSINH | ||||
| XMATCH | EUROCONVERT | IMSQRT | ||||
| XIRR | EVEN | IMSUB | ||||
| XNPV | EXAKT | IMSUM | ||||
| YEAR | EXPAND | IMTAN | ||||
| YEARFRAC | EXPON.DIST | IMTANH | ||||
| EXPONDIST | INDIRECT | |||||
| F.DIST | INTERCEPT | |||||
| F.DIST.RT | INTRATE | |||||
| F.INV | IPMT | |||||
| F.INV.RT | ISDATE | |||||
| F.TEST | ISEMAIL | |||||
| FACT | ISERR | |||||
| FACTDOUBLE | ISEVEN | |||||
| FDIST | ISFORMULA | |||||
| FILTERXML | ISLOGISCH | |||||
| FINV | ISNONTEXT | |||||
| FISHER | ISO.CEILING | |||||
| FISCHERINV | ISODD | |||||
| FIXED | ISOWEEKNUM | |||||
| FLOOR | ISPMT | |||||
| FLOOR.MATH | ISREF | |||||
| FLOOR.PRECISE | ISTEXT | |||||
| FORECAST | JOIN | |||||
| FORECAST.ETS | KURT | |||||
| PROGNOSE.ETS.CONFINT | LAMBDA | |||||
| PROGNOSE.ETS.SAISONALITÄT | LCM | |||||
| PROGNOSE.ETS.STAT | LET | |||||
| PROGNOSE.LINEAR | LINEST | |||||
| FORMELTEXT | LOG | |||||
| FREQUENZ | LOG10 | |||||
| FTEST | LOGEST | |||||
| FVSCHEDULE | LOOKUP | |||||
| GAMMA | MDURATION | |||||
| GAMMA.DIST | MINUTE | |||||
| GAMMA.INV | MIRR | |||||
| GAMMADIST | MODUS | |||||
| GAMMAINV | MULTINOMIAL | |||||
| GAMMALN | MUNIT | |||||
| GAMMALN.PRÄZISE | n. z. | |||||
| GAUSS | NEGBINOMDIST | |||||
| GCD | NOMINAL | |||||
| GEOMEAN | NORMDIST | |||||
| GESTEP | NORMINV | |||||
| GETPIVOTDATA | HEUTE | |||||
| GROUPBY | NPER | |||||
| WACHSTUM | OCT2BIN | |||||
| HARMEAN | OCT2DEC | |||||
| HEX2BIN | OCT2HEX | |||||
| HEX2DEC | ODD | |||||
| HEX2OCT | OFFSET | |||||
| STUNDE | PDURATION | |||||
| HEX2OCT | PEARSON | |||||
| HYPERLINK | PERMUT | |||||
| HYPGEOM.DIST | PERMUTATIONA | |||||
| HYPGEOMDIST | PHI | |||||
| IMABS | PI | |||||
| IMAGE | PPMT | |||||
| IMAGINÄR | PREIS | |||||
| IMARGUMENT | PRICEDISC | |||||
| IMCONJUGATE | PRICEMAT | |||||
| IMCOS | PROB | |||||
| IMCOSH | ABFRAGE | |||||
| IMCOT | QUOTIENT | |||||
| IMCSC | RADIANS | |||||
| IMCSCH | RAND | |||||
| IMDIV | RANDARRAY | |||||
| IMEXP | RANDBETWEEN | |||||
| IMLN | RATE | |||||
| IMLOG10 | EMPFANGEN | |||||
| IMLOG2 | REGEXEXTRACT | |||||
| IMPOWER | REGEXMATCH | |||||
| IMPORTCSV | REGEXREPLACE | |||||
| IMPORTTEXT | REPLACE | |||||
| IMPRODUKT | ROW | |||||
| IMREAL | RRI | |||||
| IMSEC | RSQ | |||||
| IMSECH | SEC | |||||
| IMSIN | SECH | |||||
| IMSINH | SECOND | |||||
| IMSQRT | SERIESSUM | |||||
| IMSUB | SIN | |||||
| IMSUM | SINH | |||||
| IMTAN | SKEW | |||||
| INDIRECT | SLN | |||||
| INFO | SLOPE | |||||
| INTERCEPT | SORTN | |||||
| INTRATE | SPARKLINE | |||||
| IPMT | SPLIT | |||||
| ISERR | SQRTPI | |||||
| ISEVEN | STANDARDIIEREN | |||||
| ISFORMULA | STDEVP | |||||
| ISLOGISCH | STEYX | |||||
| ISNONTEXT | SUMSQ | |||||
| ISO.CEILING | SCHALTEN | |||||
| ISODD | SYD | |||||
| ISOMITTED | T | |||||
| ISOWEEKNUM | T.DIST | |||||
| ISPMT | T.TEST | |||||
| ISREF | TAN | |||||
| ISTEXT | TANH | |||||
| JIS | TBILLEQ | |||||
| KURT | TBILLPRICE | |||||
| LAMBDA | TBILLYIELD | |||||
| LCM | ZEIT | |||||
| LET | ZEITWERT | |||||
| LINEST | TINV | |||||
| LOG | HEUTE | |||||
| LOG10 | TREND | |||||
| LOGEST | TRIMMEAN | |||||
| LOGINV | TYP | |||||
| LOGNORM.DIST | VAR | |||||
| LOGNORM.INV | VARA | |||||
| LOGNORMDIST | VARP | |||||
| LOOKUP | VDB | |||||
| MAKEARRAY | WOCHENNUMMER | |||||
| MAP | WEIBULL | |||||
| MDETERM | XOR | |||||
| MDURATION | YIELD | |||||
| MINUTE | YIELDDISC | |||||
| MINVERSE | YIELDMAT | |||||
| MIRR | ZTEST | |||||
| MODUS | ||||||
| MODE.MULT | ||||||
| MODE.SNGL | ||||||
| MULTINOMIAL | ||||||
| MUNIT | ||||||
| N | ||||||
| n. z. | ||||||
| NEGBINOM.DIST | ||||||
| NEGBINOMDIST | ||||||
| NOMINAL | ||||||
| NORM.DIST | ||||||
| NORM.INV | ||||||
| NORM.S.DIST | ||||||
| NORM.S.INV | ||||||
| NORMDIST | ||||||
| NORMINV | ||||||
| NORMSDIST | ||||||
| NORMSINV | ||||||
| HEUTE | ||||||
| NPER | ||||||
| ZIFFERNWERT | ||||||
| OCT2BIN | ||||||
| OCT2DEC | ||||||
| OCT2HEX | ||||||
| ODD | ||||||
| ODDFPRICE | ||||||
| ODDFYIELD | ||||||
| ODDLPRICE | ||||||
| ODDLYIELD | ||||||
| OFFSET | ||||||
| PDURATION | ||||||
| PEARSON | ||||||
| PERCENTRANK | ||||||
| PROZENTUALER ANTEIL.EXC | ||||||
| PERCENTRANK.INC | ||||||
| PERMUT | ||||||
| PERMUTATIONA | ||||||
| PHI | ||||||
| PHONETISCH | ||||||
| PI | ||||||
| PIVOTBY | ||||||
| POISSON | ||||||
| POISSON.DIST | ||||||
| PPMT | ||||||
| PREIS | ||||||
| PRICEDISC | ||||||
| PRICEMAT | ||||||
| PROB | ||||||
| QUOTIENT | ||||||
| RADIANS | ||||||
| RAND | ||||||
| RANDARRAY | ||||||
| RANDBETWEEN | ||||||
| RATE | ||||||
| EMPFANGEN | ||||||
| REDUZIEREN | ||||||
| REGISTER.ID | ||||||
| REPLACE, REPLACEB s | ||||||
| RÖMISCH | ||||||
| ROW | ||||||
| RRI | ||||||
| RSQ | ||||||
| RTD | ||||||
| SCAN | ||||||
| SEC | ||||||
| SECH | ||||||
| SECOND | ||||||
| SERIESSUM | ||||||
| BLÄTTERN SIE | ||||||
| BLÄTTER | ||||||
| SIN | ||||||
| SINH | ||||||
| SKEW | ||||||
| SKEW.P | ||||||
| SLN | ||||||
| SLOPE | ||||||
| SORTBY | ||||||
| SQRTPI | ||||||
| STANDARDIIEREN | ||||||
| STDEVP | ||||||
| STEYX | ||||||
| STOCKHISTORY | ||||||
| SUMSQ | ||||||
| SUMX2MY2 | ||||||
| SUMX2PY2 | ||||||
| SUMXMY2 | ||||||
| SCHALTEN | ||||||
| SYD | ||||||
| T | ||||||
| T.DIST | ||||||
| T.DIST.2T | ||||||
| T.DIST.RT | ||||||
| T.INV | ||||||
| T.INV.2T | ||||||
| T.TEST | ||||||
| TAN | ||||||
| TANH | ||||||
| TBILLEQ | ||||||
| TBILLPRICE | ||||||
| TBILLYIELD | ||||||
| TDIST | ||||||
| TEXTAFTER | ||||||
| TEXTBEFORE | ||||||
| ZEIT | ||||||
| ZEITWERT | ||||||
| TINV | ||||||
| HEUTE | ||||||
| TREND | ||||||
| TRIMMEAN | ||||||
| TRIMRANGE | ||||||
| WAHR | ||||||
| TTEST | ||||||
| TYP | ||||||
| VALUETOTEXT | ||||||
| VAR | ||||||
| VAR.P | ||||||
| VAR.S | ||||||
| VARA | ||||||
| VARP | ||||||
| VARPA | ||||||
| VDB | ||||||
| WEBSERVICE | ||||||
| WOCHENNUMMER | ||||||
| WEIBULL | ||||||
| WEIBULL.DIST | ||||||
| WRAPCOLS | ||||||
| WRAPROWS | ||||||
| XOR | ||||||
| YIELD | ||||||
| YIELDDISC | ||||||
| YIELDMAT | ||||||
| Z.TEST | ||||||
| ZTEST |