Funcții¶

Funcțiile foilor de calcul sunt împărțite în următoarele categorii:

Bază de date
Data
Inginerie
Financial
Informații
Logical
Căutare
Matematică
Diverse
Odoo
Operatori
Statistice
Text

Notă

Formulele care conțin funcții care nu sunt compatibile cu Excel sunt înlocuite cu rezultatul lor evaluat la exportul unei foi de calcul.

Baza de date¶

Nume și argumente	Descriere sau link
DAVERAGE(bază de date, câmp, criterii)	Excel DAVERAGE article
DCOUNT(bază de date, câmp, criterii)	Excel DCOUNT article
DCOUNTA(bază de date, câmp, criterii)	Excel DCOUNTA article
DGET(bază de date, câmp, criterii)	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

Dată¶

Nume și argumente	Descriere sau link
DATE(year, month, day)	Excel DATE article
DATEVALUE(date_string)	Excel DATEVALUE article
DAY(date)	Articol Excel DAY
DAYS(data_sfârșit, data_început)	Articol Excel DAYS
DAYS360(data_începutului, data_sfârșitului, [metoda])	Articol Excel DAYS360
EDATE(data_început, luni)	Articol Excel EDATE
EOMONTH(data_de începere, luni)	Articol Excel EOMONTH
ORA(timp)	Articol Excel HOUR
ISOWEEKNUM(data)	Articol Excel ISOWEEKNUM
MINUT(timp)	Articol Excel MINUTE
LUNĂ(data)	Articolul Excel MONTH
NETWORKDAYS(data_început, data_final, [vacanțe])	Articol Excel NETWORKDAYS
NETWORKDAYS.INTL(data_început, data_final, [weekend], [vacanțe])	Articol Excel NETWORKDAYS.INTL
ACUM()	Articol Excel NOW
A doua oară)	Excel SECOND article
TIME(oră, minut, secundă)	Excel TIME article
TIMEVALUE(șir de timp)	Excel TIMEVALUE article
ASTĂZI()	Excel TODAY article
WEEKDAY(data, [tip])	Excel WEEKDAY article
WEEKNUM(data, [tip])	Excel WEEKNUM article
WORKDAY(data_începerii, num_zile, [vacanțe])	Excel WORKDAY article
WORKDAY.INTL(data_început, num_zile, [weekend], [vacanțe])	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)	First day of the year a specific date falls in (not compatible with Excel)
YEAR.END(date)	Last day of the year a specific date falls in (not compatible with Excel)

Inginerie.¶

Nume și argumente	Descriere sau link
DELTA(number1, [number2])	Excel DELTA article

Financiar¶

Nume și argumente	Descriere sau link
ACCRINTM(issue, maturity, rate, redemption, [day_count_convention])	Excel ACCRINTM article
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [day_count_convention])	Excel AMORLINC article
COUPDAYS(settlement, maturity, frequency, [day_count_convention])	Excel COUPDAYS article
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])	Excel COUPDAYBS article
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])	Excel COUPDAYSNC article
COUPNCD(settlement, maturity, frequency, [day_count_convention])	Excel COUPNCD article
COUPNUM(settlement, maturity, frequency, [day_count_convention])	Excel COUPNUM article
COUPPCD(settlement, maturity, frequency, [day_count_convention])	Excel COUPPCD article
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, [end_or_beginning])	Excel CUMIPMT article
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 IPMT article
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

Informații¶

Nume și argumente	Descriere sau link
ISERR(value)	Excel IS article
ISERROR(value)	Excel IS article
ISLOGICAL(value)	Excel IS article
ISNA(value)	Excel IS article
ISNONTEXT(value)	Excel IS article
ISNUMBER(value)	Excel IS article
ISTEXT(value)	Excel IS article
ISBLANK(value)	Excel IS article
NA()	Excel NA article

Logic¶

Nume și argumente	Descriere sau 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

Căutare¶

Nume și argumente	Descriere sau 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

Matematică¶

Nume și argumente	Descriere sau 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, …])	Counts number of unique values in a range, filtered by a set of criteria (not compatible with Excel)
CSC(angle)	Excel CSC article
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 TANH article
TRUNC(value, [places])	Excel TRUNC article

Diverse¶

Nume și argumente	Descriere sau link
FORMAT.LARGE.NUMBER(value, [unit])	Aplicați un format de număr mare (nu este compatibil cu Excel)

Odoo¶

Nume și argumente	Descriere sau link
ODOO.CREDIT(account_codes, date_range, [offset], [company_id], [include_unposted])	Obțineți creditul total pentru conturile și perioada specificate (nu este compatibil cu Excel)
ODOO.DEBIT(account_codes, date_range, [offset], [company_id], [include_unposted])	Obțineți debitul total pentru conturile și perioada specificate (nu este compatibil cu Excel)
ODOO.BALANCE(account_codes, date_range, [offset], [company_id], [include_unposted])	Obțineți soldul total pentru conturile și perioada specificate (nu este compatibil cu Excel)
ODOO.FISCALYEAR.START(day, [company_id])	Returnează data de începere a anului fiscal care cuprinde data furnizată (nu este compatibilă cu Excel)
ODOO.FISCALYEAR.END(day, [company_id])	Returnează data de încheiere a anului fiscal care cuprinde data furnizată (nu este compatibilă cu Excel)
ODOO.ACCOUNT.GROUP(type)	Returnează ID-urile de cont ale unui anumit grup (nu sunt compatibile cu Excel)
ODOO.CURRENCY.RATE(currency_from, currency_to, [date])	Această funcție ia ca argumente două coduri de monedă și returnează cursul de schimb de la prima monedă la a doua ca float (nu este compatibil cu Excel)
ODOO.LIST(list_id, index, field_name)	Obțineți valoarea dintr-o listă (nu este compatibilă cu Excel)
ODOO.LIST.HEADER(list_id, field_name)	Obțineți antetul unei liste (nu este compatibil cu Excel)
ODOO.FILTER.VALUE(filter_name)	Returnează valoarea curentă a unui filtru de foaie de calcul (nu este compatibil cu Excel)
ODOO.PIVOT(pivot_id, measure_name, [domain_field_name, …], [domain_value, …])	Obțineți valoarea dintr-un pivot (nu este compatibil cu Excel)
ODOO.PIVOT.HEADER(pivot_id, [domain_field_name, …], [domain_value, …])	Obțineți antetul unui pivot (nu este compatibil cu Excel)

Operatori¶

Nume și argumente	Descriere sau link
ADD(valoare1, valoare2)	Suma a două numere (nu este compatibil cu Excel)
CONCAT(valoare1, valoare2)	Excel CONCAT article
DIVIDE(dividend, divizor)	Un număr împărțit la altul (nu este compatibil cu Excel)
EQ(valoare1, valoare2)	Egal (nu este compatibil cu Excel)
GT(valoare1, valoare2)	Strict mai mare decât (nu este compatibil cu Excel)
GTE(valoare1, valoare2)	Mai mare sau egal cu (nu este compatibil cu Excel)
LT(valoare1, valoare2)	Mai puțin decât (nu este compatibil cu Excel)
LTE(valoare1, valoare2)	Mai mic sau egal cu (nu este compatibil cu Excel)
MINUS(valoare1, valoare2)	Diferența de două numere (nu este compatibil cu Excel)
MULTIPLY(factor1, factor2)	Produs din două numere (nu este compatibil cu Excel)
NE(valoare1, valoare2)	Nu este egal (nu este compatibil cu Excel)
POW(bază, exponent)	Un număr ridicat la o putere (nu este compatibil cu Excel)
UMINUS(valoare)	Un număr cu semnul inversat (nu este compatibil cu Excel)
UNARY.PERCENT(procent)	Valoare interpretată ca procent (nu este compatibilă cu Excel)
UPLUS(valoare)	Un număr specificat, neschimbat (nu este compatibil cu Excel)

Statistic¶

Nume și argumente	Descriere sau link
AVEDEV(value1, [value2, …])	Excel AVEDEV article
AVERAGE(value1, [value2, …])	Excel AVERAGE article
AVERAGE.WEIGHTED(values, weights, [additional_values, …], [additional_weights, …])	Weighted average (not compatible with Excel)
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 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 PERCENTILE article
PERCENTILE.EXC(data, percentile)	Excel PERCENTILE.EXC article
PERCENTILE.INC(data, percentile)	Excel PERCENTILE.INC article
QUARTILE(data, quartile_number)	Excel QUARTILE article
QUARTILE.EXC(data, quartile_number)	Excel QUARTILE.EXC article
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¶

Nume și argumente	Descriere sau 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, …])	Concatenează elemente de matrice cu delimitator (nu este compatibil cu Excel)
LEFT(text, [număr_de_caractere])	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

Edit on GitHub