Funcții

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

  • Matrice

  • Bază de date

  • Data

  • Inginerie

  • Filtrați

  • Financial

  • Informații

  • Logical

  • Căutare

  • Matematică

  • Diverse

  • Odoo

  • Operatori

  • Statistice

  • Text

  • Web

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.

Șir

Nume și argumente

Descriere sau link

ARRAY.CONSTRAIN(interval_input, rânduri, coloane)

Returnează o matrice de rezultate constrânsă la o anumită lățime și înălțime (nu este compatibil cu Excel)

CHOOSECOLS(array, col_num, [col_num2, …])

Articol Excel CHOOSECOLS

CHOOSEROWS(array, row_num, [row_num2, …])

Excel CHOOSEROWS article

EXPAND(array, rows, [columns], [pad_with])

Excel EXPAND article

FLATTEN(range, [range2, …])

Flattens all the values from one or more ranges into a single column (not compatible with Excel)

FREQUENCY(data, classes)

Excel FREQUENCY article

HSTACK(range1, [range2, …])

Excel HSTACK article

MDETERM(square_matrix)

Excel MDETERM article

MINVERSE(square_matrix)

Excel MINVERSE article

MMULT(matrix1, matrix2)

Excel MMULT article

SUMPRODUCT(range1, [range2, …])

Excel SUMPRODUCT article

SUMX2MY2(array_x, array_y)

Excel SUMX2MY2 article

SUMX2PY2(array_x, array_y)

Excel SUMX2PY2 article

SUMXMY2(array_x, array_y)

Excel SUMXMY2 article

TOCOL(array, [ignore], [scan_by_column])

Excel TOCOL article

TOROW(array, [ignore], [scan_by_column])

Excel TOROW article

TRANSPOSE(range)

Excel TRANSPOSE article

VSTACK(range1, [range2, …])

Excel VSTACK article

WRAPCOLS(range, wrap_count, [pad_with])

Excel WRAPCOLS article

WRAPROWS(range, wrap_count, [pad_with])

Excel WRAPROWS article

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

DATEDIF(start_date, end_date, unit)

Excel DATEDIF 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

Filtru

Nume și argumente

Descriere sau link

FILTER(range, condition1, [condition2, …])

Excel FILTER article

UNIQUE(range, [by_column], [exactly_once])

Excel UNIQUE 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

FALSE()

Excel FALSE 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

TRUE()

Excel TRUE article

XOR(logical_expression1, [logical_expression2, …])

Excel XOR article

Căutare

Nume și argumente

Descriere sau link

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

Excel ADDRESS article

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

INT(value)

Excel INT 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

MUNIT(dimension)

Excel MUNIT 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

RANDARRAY([rows], [columns], [min], [max], [whole_number])

Excel RANDARRAY 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)

ODOO.PIVOT.TABLE(pivot_id, [row_count], [include_total], [include_column_titles])

Obțineți un tabel 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

CORREL(data_y, data_x)

Excel CORREL 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

FORECAST(x, data_y, data_x)

Excel FORECAST article

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

Fits points to exponential growth trend (not compatible with Excel)

INTERCEPT(data_y, data_x)

Excel INTERCEPT article

LARGE(data, n)

Excel LARGE article

LINEST(data_y, [data_x], [calculate_b], [verbose])

Excel LINEST article

LOGEST(data_y, [data_x], [calculate_b], [verbose])

Excel LOGEST article

MATTHEWS(data_x, data_y)

Compute the Matthews correlation coefficient of a dataset (not compatible with Excel)

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

PEARSON(data_y, data_x)

Excel PEARSON article

PERCENTILE(data, percentile)

Excel PERCENTILE article

PERCENTILE.EXC(data, percentile)

Excel PERCENTILE.EXC article

PERCENTILE.INC(data, percentile)

Excel PERCENTILE.INC article

POLYFIT.COEFFS(data_y, data_x, order, [intercept])

Compute the coefficients of polynomial regression of the dataset (not compatible with Excel)

POLYFIT.FORECAST(x, data_y, data_x, order, [intercept])

Predict value by computing a polynomial regression of the dataset (not compatible with Excel)

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

RANK(value, data, [is_ascending])

Excel RANK article

RSQ(data_y, data_x)

Excel RSQ article

SMALL(data, n)

Excel SMALL article

SLOPE(data_y, data_x)

Excel SLOPE article

SPEARMAN(data_y, data_x)

Compute the Spearman rank correlation coefficient of a dataset (not compatible with Excel)

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

STEYX(data_y, data_x)

Excel STEYX article

TREND(known_data_y, [known_data_x], [new_data_x], [b])

Fits points to linear trend derived via least-squares (not compatible with Excel)

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

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Excel TEXTSPLIT 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

Internet

Nume și argumente

Descriere sau link

HYPERLINK(url, [link_label])

Excel HYPERLINK article