Funktionen

Tabellenkalkulationsfunktionen sind in die folgenden Kategorien unterteilt:

Bemerkung

Formeln, die Funktionen enthalten, die nicht mit Excel kompatibel sind, werden beim Exportieren eines Arbeitsblatts durch ihr ausgewertetes Ergebnis ersetzt.

Datenbank

Name und Argumente

Beschreibung oder Link

DAVERAGE(database, field, criteria)

Excel DAVERAGE article

DCOUNT(database, field, criteria)

Excel-Artikel DCOUNT

DCOUNTA(database, field, criteria)

Excel DCOUNTA article

DGET(database, field, criteria)

Excel DGET article

DMAX(database, field, criteria)

Excel DMAX article

DMIN(database, field, criteria)

Excel DMIN article

DPRODUCT(database, field, criteria)

Excel DPRODUCT article

DSTDEV(database, field, criteria)

Excel DSTDEV article

DSTDEVP(database, field, criteria)

Excel DSTDEVP article

DSUM(database, field, criteria)

Excel DSUM article

DVAR(database, field, criteria)

Excel DVAR article

DVARP(database, field, criteria)

Excel DVARP article

Datum

Name und Argumente

Beschreibung oder Link

DATE(year, month, day)

Excel DATE article

DATEVALUE(date_string)

Excel DATEVALUE article

DAY(date)

Excel DAY article

DAYS(end_date, start_date)

Excel DAYS article

DAYS360(start_date, end_date, [method])

Excel DAYS360 article

EDATE(start_date, months)

Excel EDATE article

EOMONTH(start_date, months)

Excel EOMONTH article

HOUR(time)

Excel HOUR article

ISOWEEKNUM(date)

Excel ISOWEEKNUM article

MINUTE(time)

Excel MINUTE article

MONTH(date)

Excel MONTH article

NETWORKDAYS(start_date, end_date, [holidays])

Excel NETWORKDAYS article

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Excel NETWORKDAYS.INTL article

NOW()

Excel NOW article

SECOND(time)

Excel SECOND article

TIME(hour, minute, second)

Excel TIME article

TIMEVALUE(time_string)

Excel TIMEVALUE article

TODAY()

Excel TODAY article

WEEKDAY(date, [type])

Excel WEEKDAY article

WEEKNUM(date, [type])

Excel WEEKNUM article

WORKDAY(start_date, num_days, [holidays])

Excel WORKDAY article

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

Excel WORKDAY.INTL article

YEAR(date)

Excel YEAR article

YEARFRAC(start_date, end_date, [day_count_convention])

Exact number of years between two dates (not compatible with Excel)

MONTH.START(date)

First day of the month preceding a date (not compatible with Excel)

MONTH.END(date)

Last day of the month following a date (not compatible with Excel)

QUARTER(date)

Quarter of the year a specific date falls in (not compatible with Excel)

QUARTER.START(date)

First day of the quarter of the year a specific date falls in (not compatible with Excel)

QUARTER.END(date)

Last day of the quarter of the year a specific date falls in (not compatible with Excel)

YEAR.START(date)

Erster Tag des Jahres, in das ein bestimmtes Datum fällt (nicht mit Excel kompatibel)

YEAR.END(date)

Letzter Tag des Jahres, in das ein bestimmtes Datum fällt (nicht mit Excel kompatibel)

Technik

Name und Argumente

Beschreibung oder Link

DELTA(number1, [number2])

Excel-Artikel DELTA

Finanziell

Name und Argumente

Beschreibung oder Link

ACCRINTM(issue, maturity, rate, redemption, [day_count_convention])

Excel-Artikel ACCRINTM article

AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [day_count_convention])

Excel-Artikel AMORLINC

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPDAYS

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPDAYBS

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPDAYSNC

COUPNCD(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPNCD

COUPNUM(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPNUM

COUPPCD(settlement, maturity, frequency, [day_count_convention])

Excel-Artikel COUPPCD

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, [end_or_beginning])

Excel-Artikel CUMIPMT

CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, [end_or_beginning])

Excel CUMPRINC article

DB(cost, salvage, life, period, [month])

Excel DB article

DDB(cost, salvage, life, period, [factor])

Excel DDB article

DISC(settlement, maturity, price, redemption, [day_count_convention])

Excel DISC article

DOLLARDE(fractional_price, unit)

Excel DOLLARDE article

DOLLARFR(decimal_price, unit)

Excel DOLLARFR article

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

Excel DURATION article

EFFECT(nominal_rate, periods_per_year)

Excel EFFECT article

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

Excel FV article

FVSCHEDULE(principal, rate_schedule)

Excel FVSCHEDULE article

INTRATE(settlement, maturity, investment, redemption, [day_count_convention])

Excel INTRATE article

IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Excel-Artikel IPMT

IRR(cashflow_amounts, [rate_guess])

Excel IRR article

ISPMT(rate, period, number_of_periods, present_value)

Excel ISPMT article

MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

Excel MDURATION article

MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)

Excel MIRR article

NOMINAL(effective_rate, periods_per_year)

Excel NOMINAL article

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

Excel NPER article

NPV(discount, cashflow1, [cashflow2, …])

Excel NPV article

PDURATION(rate, present_value, future_value)

Excel PDURATION article

PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])

Excel PMT article

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

Excel PPMT article

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

Excel PV article

PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

Excel PRICE article

PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

Excel PRICEDISC article

PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

Excel PRICEMAT article

RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])

Excel RATE article

RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

Excel RECEIVED article

RRI(number_of_periods, present_value, future_value)

Excel RRI article

SLN(cost, salvage, life)

Excel SLN article

SYD(cost, salvage, life, period)

Excel SYD article

TBILLPRICE(settlement, maturity, discount)

Excel TBILLPRICE article

TBILLEQ(settlement, maturity, discount)

Excel TBILLEQ article

TBILLYIELD(settlement, maturity, price)

Excel TBILLYIELD article

VDB(cost, salvage, life, start, end, [factor], [no_switch])

Excel VDB article

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

Excel XIRR article

XNPV(discount, cashflow_amounts, cashflow_dates)

Excel XNPV article

YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])

Excel YIELD article

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

Excel YIELDDISC article

YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])

Excel YIELDMAT article

Information

Name und Argumente

Beschreibung oder Link

ISERR(value)

Excel-Artikel IS

ISERROR(value)

Excel-Artikel IS

ISLOGICAL(value)

Excel-Artikel IS

ISNA(value)

Excel-Artikel IS

ISNONTEXT(value)

Excel-Artikel IS

ISNUMBER(value)

Excel-Artikel IS

ISTEXT(value)

Excel-Artikel IS

ISBLANK(value)

Excel-Artikel IS

NA()

Excel NA article

Logisch

Name und Argumente

Beschreibung oder Link

AND(logical_expression1, [logical_expression2, …])

Excel AND article

IF(logical_expression, value_if_true, [value_if_false])

Excel IF article

IFERROR(value, [value_if_error])

Excel IFERROR article

IFNA(value, [value_if_error])

Excel IFNA article

IFS(condition1, value1, [condition2, …], [value2, …])

Excel IFS article

NOT(logical_expression)

Excel NOT article

OR(logical_expression1, [logical_expression2, …])

Excel OR article

XOR(logical_expression1, [logical_expression2, …])

Excel XOR article

Nachschlagen

Name und Argumente

Beschreibung oder Link

COLUMN([cell_reference])

Excel COLUMN article

COLUMNS(range)

Excel COLUMNS article

HLOOKUP(search_key, range, index, [is_sorted])

Excel HLOOKUP article

INDEX(reference, row, column)

Excel INDEX article

LOOKUP(search_key, search_array, [result_range])

Excel LOOKUP article

MATCH(search_key, range, [search_type])

Excel MATCH article

ROW([cell_reference])

Excel ROW article

ROWS(range)

Excel ROWS article

VLOOKUP(search_key, range, index, [is_sorted])

Excel VLOOKUP article

XLOOKUP(search_key, lookup_range, return_range, [if_not_found], [match_mode], [search_mode])

Excel XLOOKUP article

Mathe

Name und Argumente

Beschreibung oder Link

ABS(value)

Excel ABS article

ACOS(value)

Excel ACOS article

ACOSH(value)

Excel ACOSH article

ACOT(value)

Excel ACOT article

ACOTH(value)

Excel ACOTH article

ASIN(value)

Excel ASIN article

ASINH(value)

Excel ASINH article

ATAN(value)

Excel ATAN article

ATAN2(x, y)

Excel ATAN2 article

ATANH(value)

Excel ATANH article

CEILING(value, [factor])

Excel CEILING article

CEILING.MATH(number, [significance], [mode])

Excel CEILING.MATH article

CEILING.PRECISE(number, [significance])

Excel CEILING.PRECISE article

COS(angle)

Excel COS article

COSH(value)

Excel COSH article

COT(angle)

Excel COT article

COTH(value)

Excel COTH article

COUNTBLANK(value1, [value2, …])

Excel COUNTBLANK article

COUNTIF(range, criterion)

Excel COUNTIF article

COUNTIFS(criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Excel COUNTIFS article

COUNTUNIQUE(value1, [value2, …])

Counts number of unique values in a range (not compatible with Excel)

COUNTUNIQUEIFS(range, criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Zählt die Anzahl der eindeutigen Werte in einem Bereich, gefiltert nach einer Reihe von Kriterien (nicht mit Excel kompatibel).

CSC(angle)

Excel-Artikel CSC

CSCH(value)

Excel CSCH article

DECIMAL(value, base)

Excel DECIMAL article

DEGREES(angle)

Excel DEGREES article

EXP(value)

Excel EXP article

FLOOR(value, [factor])

Excel FLOOR article

FLOOR.MATH(number, [significance], [mode])

Excel FLOOR.MATH article

FLOOR.PRECISE(number, [significance])

Excel FLOOR.PRECISE article

ISEVEN(value)

Excel ISEVEN article

ISO.CEILING(number, [significance])

Excel ISO.CEILING article

ISODD(value)

Excel ISODD article

LN(value)

Excel LN article

MOD(dividend, divisor)

Excel MOD article

ODD(value)

Excel ODD article

PI()

Excel PI article

POWER(base, exponent)

Excel POWER article

PRODUCT(factor1, [factor2, …])

Excel PRODUCT article

RAND()

Excel RAND article

RANDBETWEEN(low, high)

Excel RANDBETWEEN article

ROUND(value, [places])

Excel ROUND article

ROUNDDOWN(value, [places])

Excel ROUNDDOWN article

ROUNDUP(value, [places])

Excel ROUNDUP article

SEC(angle)

Excel SEC article

SECH(value)

Excel SECH article

SIN(angle)

Excel SIN article

SINH(value)

Excel SINH article

SQRT(value)

Excel SQRT article

SUM(value1, [value2, …])

Excel SUM article

SUMIF(criteria_range, criterion, [sum_range])

Excel SUMIF article

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Excel SUMIFS article

TAN(angle)

Excel TAN article

TANH(value)

Excel-Artikel zu TANH

TRUNC(value, [places])

Excel-Artikel zu TRUNC

Diverse

Name und Argumente

Beschreibung oder Link

FORMAT.LARGE.NUMBER(value, [unit])

Anwendung eines größeren Zahlenformats (nicht mit Excel kompatibel)

Odoo

Name und Argumente

Beschreibung oder Link

ODOO.CREDIT(account_codes, date_range, [offset], [company_id], [include_unposted])

Ermittelt das Gesamtguthaben für die angegebenen Konten und den Zeitraum (nicht mit Excel kompatibel)

ODOO.DEBIT(account_codes, date_range, [offset], [company_id], [include_unposted])

Ermittelt die Gesamtbelastung für die angegebenen Konten und den Zeitraum (nicht mit Excel kompatibel)

ODOO.BALANCE(account_codes, date_range, [offset], [company_id], [include_unposted])

Ermittelt den Gesamtsaldo für die angegebene Konten und den Zeitraum (nicht mit Excel kompatibel)

ODOO.FISCALYEAR.START(day, [company_id])

Gibt das Anfangsdatum des Geschäftsjahres zurück, das das angegebene Datum einschließt (nicht mit Excel kompatibel)

ODOO.FISCALYEAR.END(day, [company_id])

Gibt das Enddatum des Geschäftsjahres zurück, das das angegebene Datum einschließt (nicht mit Excel kompatibel)

ODOO.ACCOUNT.GROUP(type)

Gibt die Konto-IDs eine bestimmten Gruppe zurück (nicht mit Excel kompatibel).

ODOO.CURRENCY.RATE(currency_from, currency_to, [date])

Diese Funktion nimmt zwei Währungscodes als Argumente und gibt den Wechselkurs von der ersten Währung in die zweite als Gleitkommazahl zurück (nicht mit Excel kompatibel)

ODOO.LIST(list_id, index, field_name)

Gibt den Wert aus einer Liste (nicht mit Excel kompatibel)

ODOO.LIST.HEADER(list_id, field_name)

Gibt die Koptzeile einer Liste (nicht mit Excel kompatibel)

ODOO.FILTER.VALUE(filter_name)

Gibt den aktuellen Wert eines Tabellenfilters zurück (nicht mit Excel kompatibel)

ODOO.PIVOT(pivot_id, measure_name, [domain_field_name, …], [domain_value, …])

Gibt den Wert aus einer Pivot-Tabelle (nicht mit Excel kompatibel)

ODOO.PIVOT.HEADER(pivot_id, [domain_field_name, …], [domain_value, …])

Gibt die Koptzeile einer Pivot-Tabelle (nicht mit Excel kompatibel)

Bediener

Name und Argumente

Beschreibung oder Link

ADD(value1, value2)

Summe von zwei Zahlen (nicht mit Excel kompatibel)

CONCAT(value1, value2)

Excel-Artikel zu CONCAT

DIVIDE(dividend, divisor)

Eine Zahl geteilt durch eine andere (nicht mit Excel kompatibel)

EQ(value1, value2)

Gleich (nicht mit Excel kompatibel)

GT(value1, value2)

Unbedingt größer als (nicht mit Excel kompatibel)

GTE(value1, value2)

Größer oder gleich (nicht mit Excel kompatibel)

LT(value1, value2)

Kleiner als (nicht mit Excel kompatibel)

LTE(value1, value2)

Kleiner oder gleich (nicht mit Excel kompatibel)

MINUS(value1, value2)

Differenz zwischen zwei Zahlen (nicht mit Excel kompatibel)

MULTIPLY(factor1, factor2)

Produkt von zwei Zahlen (nicht mit Excel kompatibel)

NE(value1, value2)

Nicht gleich (nicht mit Excel kompatibel)

POW(base, exponent)

Eine Zahl zu einer Potenz hochgezählt (nicht mit Excel kompatibel)

UMINUS(value)

Eine Zahl mit umgekehrtem Zeichen (nicht mit Excel kompatibel)

UNARY.PERCENT(percentage)

Wert, der als Prozentsatz interpretiert wird (nicht mit Excel kompatibel)

UPLUS(value)

Eine bestimmte Zahl, unverändert (nicht mit Excel kompatibel)

Statistisch

Name und Argumente

Beschreibung oder Link

AVEDEV(value1, [value2, …])

Excel AVEDEV article

AVERAGE(value1, [value2, …])

Excel AVERAGE article

AVERAGE.WEIGHTED(values, weights, [additional_values, …], [additional_weights, …])

Gewichteter Durchschnitt (nicht mit Excel kompatibel)

AVERAGEA(value1, [value2, …])

Excel AVERAGEA article

AVERAGEIF(criteria_range, criterion, [average_range])

Excel AVERAGEIF article

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Excel-Artikel AVERAGEIFS article

COUNT(value1, [value2, …])

Excel COUNT article

COUNTA(value1, [value2, …])

Excel COUNTA article

COVAR(data_y, data_x)

Excel COVAR article

COVARIANCE.P(data_y, data_x)

Excel COVARIANCE.P article

COVARIANCE.S(data_y, data_x)

Excel COVARIANCE.S article

LARGE(data, n)

Excel LARGE article

MAX(value1, [value2, …])

Excel MAX article

MAXA(value1, [value2, …])

Excel MAXA article

MAXIFS(range, criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Excel MAXIFS article

MEDIAN(value1, [value2, …])

Excel MEDIAN article

MIN(value1, [value2, …])

Excel MIN article

MINA(value1, [value2, …])

Excel MINA article

MINIFS(range, criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])

Excel MINIFS article

PERCENTILE(data, percentile)

Excel-Artikel PERCENTILE

PERCENTILE.EXC(data, percentile)

Excel-Artikel PERCENTILE.EXC

PERCENTILE.INC(data, percentile)

Excel-Artikel PERCENTILE.INC

QUARTILE(data, quartile_number)

Excel-Artikel QUARTILE

QUARTILE.EXC(data, quartile_number)

Excel-Artikel QUARTILE.EXC

QUARTILE.INC(data, quartile_number)

Excel QUARTILE.INC article

SMALL(data, n)

Excel SMALL article

STDEV(value1, [value2, …])

Excel STDEV article

STDEV.P(value1, [value2, …])

Excel STDEV.P article

STDEV.S(value1, [value2, …])

Excel STDEV.S article

STDEVA(value1, [value2, …])

Excel STDEVA article

STDEVP(value1, [value2, …])

Excel STDEVP article

STDEVPA(value1, [value2, …])

Excel STDEVPA article

VAR(value1, [value2, …])

Excel VAR article

VAR.P(value1, [value2, …])

Excel VAR.P article

VAR.S(value1, [value2, …])

Excel VAR.S article

VARA(value1, [value2, …])

Excel VARA article

VARP(value1, [value2, …])

Excel VARP article

VARPA(value1, [value2, …])

Excel VARPA article

Text

Name und Argumente

Beschreibung oder Link

CHAR(table_number)

Excel CHAR article

CLEAN(text)

Excel CLEAN article

CONCATENATE(string1, [string2, …])

Excel CONCATENATE article

EXACT(string1, string2)

Excel EXACT article

FIND(search_for, text_to_search, [starting_at])

Excel FIND article

JOIN(delimiter, value_or_array1, [value_or_array2, …])

Concatenates elements of arrays with delimiter (not compatible with Excel)

LEFT(text, [number_of_characters])

Excel LEFT article

LEN(text)

Excel LEN article

LOWER(text)

Excel LOWER article

MID(text, starting_at, extract_length)

Excel MID article

PROPER(text_to_capitalize)

Excel PROPER article

REPLACE(text, position, length, new_text)

Excel REPLACE article

RIGHT(text, [number_of_characters])

Excel RIGHT article

SEARCH(search_for, text_to_search, [starting_at])

Excel SEARCH article

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

Excel SUBSTITUTE article

TEXT(number, format)

Excel TEXT article

TEXTJOIN(delimiter, ignore_empty, text1, [text2, …])

Excel TEXTJOIN article

TRIM(text)

Excel TRIM article

UPPER(text)

Excel UPPER article