Föll
Töflureikniföll eru flokkuð í eftirfarandi flokka:
- Fylki
- Gagnagrunnur
- Dagsetning
- Verkfræði
- Sía
- Fjármál
- Upplýsingar
- Rökfræði
- Uppfletting
- Stærðfræði
- Ýmislegt
- Odoo
- Virkjar
- Tölfræði
- Texti
- Vefur
Athugasemd
Formúlur sem innihalda föll sem eru ekki samhæf við Excel eru skipt út fyrir útreiknað gildi þeirra þegar töflureikni er flutt út.
Fylki
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
ARRAY.CONSTRAIN(input_range, rows, columns) |
Skilar niðurstöðufylki sem er takmarkað við tiltekna breidd og hæð (ekki samhæft við Excel) |
CHOOSECOLS(array, col_num, [col_num2, ...]) |
Excel CHOOSECOLS grein |
CHOOSEROWS(array, row_num, [row_num2, ...]) |
Excel CHOOSEROWS grein |
EXPAND(array, rows, [columns], [pad_with]) |
Excel EXPAND grein |
FLATTEN(range, [range2, ...]) |
Flettar öll gildi úr einu eða fleiri sviðum út í einn dálk (ekki samhæft við Excel) |
FREQUENCY(data, classes) |
Excel FREQUENCY grein |
HSTACK(range1, [range2, ...]) |
Excel HSTACK grein |
MDETERM(square_matrix) |
Excel MDETERM grein |
MINVERSE(square_matrix) |
Excel MINVERSE grein |
MMULT(matrix1, matrix2) |
Excel MMULT grein |
SUMPRODUCT(range1, [range2, ...]) |
Excel SUMPRODUCT grein |
SUMX2MY2(array_x, array_y) |
Excel SUMX2MY2 grein |
SUMX2PY2(array_x, array_y) |
Excel SUMX2PY2 grein |
SUMXMY2(array_x, array_y) |
Excel SUMXMY2 grein |
TOCOL(array, [ignore], [scan_by_column]) |
Excel TOCOL grein |
TOROW(array, [ignore], [scan_by_column]) |
Excel TOROW grein |
TRANSPOSE(range) |
Excel TRANSPOSE grein |
VSTACK(range1, [range2, ...]) |
Excel VSTACK grein |
WRAPCOLS(range, wrap_count, [pad_with]) |
Excel WRAPCOLS grein |
WRAPROWS(range, wrap_count, [pad_with]) |
Excel WRAPROWS grein |
Gagnagrunnur
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
DAVERAGE(database, field, criteria) |
Excel DAVERAGE grein |
DCOUNT(database, field, criteria) |
Excel DCOUNT grein |
DCOUNTA(database, field, criteria) |
Excel DCOUNTA grein |
DGET(database, field, criteria) |
Excel DGET grein |
DMAX(database, field, criteria) |
Excel DMAX grein |
DMIN(database, field, criteria) |
Excel DMIN grein |
DPRODUCT(database, field, criteria) |
Excel DPRODUCT grein |
DSTDEV(database, field, criteria) |
Excel DSTDEV grein |
DSTDEVP(database, field, criteria) |
Excel DSTDEVP grein |
DSUM(database, field, criteria) |
Excel DSUM grein |
DVAR(database, field, criteria) |
Excel DVAR grein |
DVARP(database, field, criteria) |
Excel DVARP grein |
Dagsetning
| Heiti og frumbreytur | Lýsing eða tengill |
|---|
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
DATE(year, month, day) |
Excel DATE grein |
DATEDIF(start_date, end_date, unit) |
Excel DATEDIF grein |
DATEVALUE(date_string) |
Excel DATEVALUE grein |
DAY(date) |
Excel DAY grein |
DAYS(end_date, start_date) |
Excel DAYS grein |
DAYS360(start_date, end_date, [method]) |
Excel DAYS360 grein |
EDATE(start_date, months) |
Excel EDATE grein |
EOMONTH(start_date, months) |
Excel EOMONTH grein |
HOUR(time) |
Excel HOUR grein |
ISOWEEKNUM(date) |
Excel ISOWEEKNUM grein |
MINUTE(time) |
Excel MINUTE grein |
MONTH(date) |
Excel MONTH grein |
NETWORKDAYS(start_date, end_date, [holidays]) |
Excel NETWORKDAYS grein |
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) |
Excel NETWORKDAYS.INTL grein |
NOW() |
Excel NOW grein |
SECOND(time) |
Excel SECOND grein |
TIME(hour, minute, second) |
Excel TIME grein |
TIMEVALUE(time_string) |
Excel TIMEVALUE grein |
TODAY() |
Excel TODAY grein |
WEEKDAY(date, [type]) |
Excel WEEKDAY grein |
WEEKNUM(date, [type]) |
Excel WEEKNUM grein |
WORKDAY(start_date, num_days, [holidays]) |
Excel WORKDAY grein |
WORKDAY.INTL(start_date, num_days, [weekend], [holidays]) |
Excel WORKDAY.INTL grein |
YEAR(date) |
Excel YEAR grein |
YEARFRAC(start_date, end_date, [day_count_convention]) |
Nákvæmt fjöldi ára á milli tveggja dagsetninga (ekki samhæft við Excel) |
MONTH.START(date) |
Fyrsti dagur mánaðarins á undan tiltekinni dagsetningu (ekki samhæft við Excel) |
MONTH.END(date) |
Síðasti dagur mánaðarins á eftir tiltekinni dagsetningu (ekki samhæft við Excel) |
QUARTER(date) |
Ársfjórðungur sem tiltekin dagsetning fellur í (ekki samhæft við Excel) |
QUARTER.START(date) |
Fyrsti dagur ársfjórðungsins sem tiltekin dagsetning fellur í (ekki samhæft við Excel) |
QUARTER.END(date) |
Síðasti dagur ársfjórðungsins sem tiltekin dagsetning fellur í (ekki samhæft við Excel) |
YEAR.START(date) |
Fyrsti dagur ársins sem tiltekin dagsetning fellur í (ekki samhæft við Excel) |
YEAR.END(date) |
Síðasti dagur ársins sem tiltekin dagsetning fellur í (ekki samhæft við Excel) |
Verkfræði
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
DELTA(number1, [number2]) |
Excel DELTA grein |
Sía
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
FILTER(range, condition1, [condition2, ...]) |
Excel FILTER grein |
UNIQUE(range, [by_column], [exactly_once]) |
Excel UNIQUE grein |
Fjármál
| Heiti og frumbreytur | Lýsing eða tengill |
|---|
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
| ACCRINTM(issue, maturity, rate, redemption, [day_count_convention]) | Excel ACCRINTM grein |
| AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [day_count_convention]) | Excel AMORLINC grein |
| COUPDAYS(settlement, maturity, frequency, [day_count_convention]) | Excel COUPDAYS grein |
| COUPDAYBS(settlement, maturity, frequency, [day_count_convention]) | Excel COUPDAYBS grein |
| COUPDAYSNC(settlement, maturity, frequency, [day_count_convention]) | Excel COUPDAYSNC grein |
| COUPNCD(settlement, maturity, frequency, [day_count_convention]) | Excel COUPNCD grein |
| COUPNUM(settlement, maturity, frequency, [day_count_convention]) | Excel COUPNUM grein |
| COUPPCD(settlement, maturity, frequency, [day_count_convention]) | Excel COUPPCD grein |
| CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, [end_or_beginning]) | Excel CUMIPMT grein |
| CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, [end_or_beginning]) | Excel CUMPRINC grein |
| DB(cost, salvage, life, period, [month]) | Excel DB grein |
| DDB(cost, salvage, life, period, [factor]) | Excel DDB grein |
| DISC(settlement, maturity, price, redemption, [day_count_convention]) | Excel DISC grein |
| DOLLARDE(fractional_price, unit) | Excel DOLLARDE grein |
| DOLLARFR(decimal_price, unit) | Excel DOLLARFR grein |
| DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) | Excel DURATION grein |
| EFFECT(nominal_rate, periods_per_year) | Excel EFFECT grein |
| FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) | Excel FV grein |
| FVSCHEDULE(principal, rate_schedule) | Excel FVSCHEDULE grein |
| INTRATE(settlement, maturity, investment, redemption, [day_count_convention]) | Excel INTRATE grein |
| IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Excel IPMT grein |
| IRR(cashflow_amounts, [rate_guess]) | Excel IRR grein |
| ISPMT(rate, period, number_of_periods, present_value) | Excel ISPMT grein |
| MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) | Excel MDURATION grein |
| MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate) | Excel MIRR grein |
| NOMINAL(effective_rate, periods_per_year) | Excel NOMINAL grein |
| NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) | Excel NPER grein |
| NPV(discount, cashflow1, [cashflow2, ...]) | Excel NPV grein |
| PDURATION(rate, present_value, future_value) | Excel PDURATION grein |
| PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) | Excel PMT grein |
| PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Excel PPMT grein |
| PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) | Excel PV grein |
| PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) | Excel PRICE grein |
| PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) | Excel PRICEDISC grein |
| PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) | Excel PRICEMAT grein |
| RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) | Excel RATE grein |
| RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) | Excel RECEIVED grein |
| RRI(number_of_periods, present_value, future_value) | Excel RRI grein |
| SLN(cost, salvage, life) | Excel SLN grein |
| SYD(cost, salvage, life, period) | Excel SYD grein |
| TBILLPRICE(settlement, maturity, discount) | Excel TBILLPRICE grein |
| TBILLEQ(settlement, maturity, discount) | Excel TBILLEQ grein |
| TBILLYIELD(settlement, maturity, price) | Excel TBILLYIELD grein |
| VDB(cost, salvage, life, start, end, [factor], [no_switch]) | Excel VDB grein |
| XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) | Excel XIRR grein |
| XNPV(discount, cashflow_amounts, cashflow_dates) | Excel XNPV grein |
| YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention]) | Excel YIELD grein |
| YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) | Excel YIELDDISC grein |
| YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]) | Excel YIELDMAT grein |
Info
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
| ISERR(value) | Excel IS grein |
| ISERROR(value) | Excel IS grein |
| ISLOGICAL(value) | Excel IS grein |
| ISNA(value) | Excel IS grein |
| ISNONTEXT(value) | Excel IS grein |
| ISNUMBER(value) | Excel IS grein |
| ISTEXT(value) | Excel IS grein |
| ISBLANK(value) | Excel IS grein |
| NA() | Excel NA grein |
Logical
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
| AND(logical_expression1, [logical_expression2, ...]) | Excel AND grein |
| FALSE() | Excel FALSE grein |
| IF(logical_expression, value_if_true, [value_if_false]) | Excel IF grein |
| IFERROR(value, [value_if_error]) | Excel IFERROR grein |
| IFNA(value, [value_if_error]) | Excel IFNA grein |
| IFS(condition1, value1, [condition2, ...], [value2, ...]) | Excel IFS grein |
| NOT(logical_expression) | Excel NOT grein |
| OR(logical_expression1, [logical_expression2, ...]) | Excel OR grein |
| TRUE() | Excel TRUE grein |
| XOR(logical_expression1, [logical_expression2, ...]) | Excel XOR grein |
Lookup
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
| ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) | Excel ADDRESS grein |
| COLUMN([cell_reference]) | Excel COLUMN grein |
| COLUMNS(range) | Excel COLUMNS grein |
| HLOOKUP(search_key, range, index, [is_sorted]) | Excel HLOOKUP grein |
| INDEX(reference, row, column) | Excel INDEX grein |
| LOOKUP(search_key, search_array, [result_range]) | Excel LOOKUP grein |
| MATCH(search_key, range, [search_type]) | Excel MATCH grein |
| ROW([cell_reference]) | Excel ROW grein |
| ROWS(range) | Excel ROWS grein |
| VLOOKUP(search_key, range, index, [is_sorted]) | Excel VLOOKUP grein |
| XLOOKUP(search_key, lookup_range, return_range, [if_not_found], [match_mode], [search_mode]) | Excel XLOOKUP grein |
Math
| Nafn og frumbreytur | Lýsing eða tengill |
|---|---|
| ABS(value) | Excel ABS grein |
| ACOS(value) | Excel ACOS grein |
| ACOSH(value) | Excel ACOSH grein |
| ACOT(value) | Excel ACOT grein |
| ACOTH(value) | Excel ACOTH grein |
| ASIN(value) | Excel ASIN grein |
| ASINH(value) | Excel ASINH grein |
| ATAN(value) | Excel ATAN grein |
| ATAN2(x, y) | Excel ATAN2 grein |
| ATANH(value) | Excel ATANH grein |
| CEILING(value, [factor]) | Excel CEILING grein |
| CEILING.MATH(number, [significance], [mode]) | Excel CEILING.MATH grein |
| CEILING.PRECISE(number, [significance]) | Excel CEILING.PRECISE grein |
| COS(angle) | Excel COS grein |
| COSH(value) | Excel COSH grein |
| COT(angle) | Excel COT grein |
| COTH(value) | Excel COTH grein |
| COUNTBLANK(value1, [value2, ...]) | Excel COUNTBLANK grein |
| COUNTIF(range, criterion) | Excel COUNTIF grein |
| COUNTIFS(criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) | Excel COUNTIFS grein |
| COUNTUNIQUE(value1, [value2, ...]) | Telur fjölda einstakra gilda í sviði (ekki samhæft við Excel) |
| COUNTUNIQUEIFS(range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) | Telur fjölda einstakra gilda í sviði, síað eftir skilyrðum (ekki samhæft við Excel) |
| CSC(angle) | Excel CSC grein |
| CSCH(value) | Excel CSCH grein |
| DECIMAL(value, base) | Excel DECIMAL grein |
| DEGREES(angle) | Excel DEGREES grein |
| EXP(value) | Excel EXP grein |
| FLOOR(value, [factor]) | Excel FLOOR grein |
| FLOOR.MATH(number, [significance], [mode]) | Excel FLOOR.MATH grein |
| FLOOR.PRECISE(number, [significance]) | Excel FLOOR.PRECISE grein |
| INT(value) | Excel INT grein |
| ISEVEN(value) | Excel ISEVEN grein |
| ISO.CEILING(number, [significance]) | Excel ISO.CEILING grein |
| ISODD(value) | Excel ISODD grein |
| LN(value) | Excel LN grein |
| MOD(dividend, divisor) | Excel MOD grein |
| MUNIT(dimension) | Excel MUNIT grein |
| ODD(value) | Excel ODD grein |
| PI() | Excel PI grein |
| POWER(base, exponent) | Excel POWER grein |
| PRODUCT(factor1, [factor2, ...]) | Excel PRODUCT grein |
| RAND() | Excel RAND grein |
| RANDARRAY([rows], [columns], [min], [max], [whole_number]) | Excel RANDARRAY grein |
| RANDBETWEEN(low, high) | Excel RANDBETWEEN grein |
| ROUND(value, [places]) | Excel ROUND grein |
| ROUNDDOWN(value, [places]) | Excel ROUNDDOWN grein |
| ROUNDUP(value, [places]) | Excel ROUNDUP grein |
| SEC(angle) | Excel SEC grein |
| SECH(value) | Excel SECH grein |
| SIN(angle) | Excel SIN grein |
| SINH(value) | Excel SINH grein |
| SQRT(value) | Excel SQRT grein |
| SUM(value1, [value2, ...]) | Excel SUM grein |
| SUMIF(criteria_range, criterion, [sum_range]) | Excel SUMIF grein |
| SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) | Excel SUMIFS grein |
| TAN(angle) | Excel TAN grein |
| TANH(value) | Excel TANH grein |
| TRUNC(value, [places]) | Excel TRUNC grein |
Ýmislegt
| Nafn og frumbreytur | Lýsing eða tengill |
|---|
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
FORMAT.LARGE.NUMBER(value, [unit]) |
Notar snið fyrir stór tölur (ekki samhæft við Excel) |
Odoo
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
ODOO.CREDIT(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Sækir heildarkreditupphæð fyrir tilgreinda reikninga og tímabil (ekki samhæft við Excel) |
ODOO.DEBIT(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Sækir heildardebitupphæð fyrir tilgreinda reikninga og tímabil (ekki samhæft við Excel) |
ODOO.BALANCE(account_codes, date_range, [offset], [company_id], [include_unposted]) |
Sækir heildarstöðu fyrir tilgreinda reikninga og tímabil (ekki samhæft við Excel) |
ODOO.FISCALYEAR.START(day, [company_id]) |
Skilar upphafsdegi reikningsársins sem tilgreind dagsetning fellur undir (ekki samhæft við Excel) |
ODOO.FISCALYEAR.END(day, [company_id]) |
Skilar lokadegi reikningsársins sem tilgreind dagsetning fellur undir (ekki samhæft við Excel) |
ODOO.ACCOUNT.GROUP(type) |
Skilar reikningsnúmerum tiltekinnar reikningaflokks (ekki samhæft við Excel) |
ODOO.CURRENCY.RATE(currency_from, currency_to, [date]) |
Tekur inn tvo gjaldmiðilskóða sem frumbreytur og skilar gengi frá fyrsta gjaldmiðlinum til þess síðara sem fleytitölu (ekki samhæft við Excel) |
ODOO.LIST(list_id, index, field_name) |
Sækir gildi úr lista (ekki samhæft við Excel) |
ODOO.LIST.HEADER(list_id, field_name) |
Sækir fyrirsögn lista (ekki samhæft við Excel) |
ODOO.FILTER.VALUE(filter_name) |
Skilar núverandi gildi síu í töflureikni (ekki samhæft við Excel) |
ODOO.PIVOT(pivot_id, measure_name, [domain_field_name, ...], [domain_value, ...]) |
Sækir gildi úr pivot-töflu (ekki samhæft við Excel) |
ODOO.PIVOT.HEADER(pivot_id, [domain_field_name, ...], [domain_value, ...]) |
Sækir fyrirsögn pivot-töflu (ekki samhæft við Excel) |
ODOO.PIVOT.TABLE(pivot_id, [row_count], [include_total], [include_column_titles]) |
Sækir pivot-töflu (ekki samhæft við Excel) |
Virkjar
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
ADD(value1, value2) |
Summa tveggja talna (ekki samhæft við Excel) |
CONCAT(value1, value2) |
Excel CONCAT grein |
DIVIDE(dividend, divisor) |
Ein tala deilt með annarri (ekki samhæft við Excel) |
EQ(value1, value2) |
Jafnt og (ekki samhæft við Excel) |
GT(value1, value2) |
Stærra en (ekki samhæft við Excel) |
GTE(value1, value2) |
Stærra en eða jafnt og (ekki samhæft við Excel) |
LT(value1, value2) |
Minna en (ekki samhæft við Excel) |
LTE(value1, value2) |
Minna en eða jafnt og (ekki samhæft við Excel) |
MINUS(value1, value2) |
Mismunur tveggja talna (ekki samhæft við Excel) |
MULTIPLY(factor1, factor2) |
Margfeldi tveggja talna (ekki samhæft við Excel) |
NE(value1, value2) |
Ekki jafnt og (ekki samhæft við Excel) |
POW(base, exponent) |
Tala í veldi (ekki samhæft við Excel) |
UMINUS(value) |
Tala með umsnúið formerki (ekki samhæft við Excel) |
UNARY.PERCENT(percentage) |
Gildi túlkað sem hlutfall (ekki samhæft við Excel) |
UPLUS(value) |
Tilgreind tala, óbreytt (ekki samhæft við Excel) |
Tölfræði
| Heiti og frumbreytur | Lýsing eða tengill |
|---|
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
AVEDEV(value1, [value2, ...]) |
Excel AVEDEV grein |
AVERAGE(value1, [value2, ...]) |
Excel AVERAGE grein |
AVERAGE.WEIGHTED(values, weights, [additional_values, ...], [additional_weights, ...]) |
Vegið meðaltal (ekki samhæft við Excel) |
AVERAGEA(value1, [value2, ...]) |
Excel AVERAGEA grein |
AVERAGEIF(criteria_range, criterion, [average_range]) |
Excel AVERAGEIF grein |
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
Excel AVERAGEIFS grein |
CORREL(data_y, data_x) |
Excel CORREL grein |
COUNT(value1, [value2, ...]) |
Excel COUNT grein |
COUNTA(value1, [value2, ...]) |
Excel COUNTA grein |
COVAR(data_y, data_x) |
Excel COVAR grein |
COVARIANCE.P(data_y, data_x) |
Excel COVARIANCE.P grein |
COVARIANCE.S(data_y, data_x) |
Excel COVARIANCE.S grein |
FORECAST(x, data_y, data_x) |
Excel FORECAST grein |
GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) |
Passar gögn við veldisvísisvaxtaþróun (ekki samhæft við Excel) |
INTERCEPT(data_y, data_x) |
Excel INTERCEPT grein |
LARGE(data, n) |
Excel LARGE grein |
LINEST(data_y, [data_x], [calculate_b], [verbose]) |
Excel LINEST grein |
LOGEST(data_y, [data_x], [calculate_b], [verbose]) |
Excel LOGEST grein |
MATTHEWS(data_x, data_y) |
Reiknar Matthews fylgistuðul gagnasafns (ekki samhæft við Excel) |
MAX(value1, [value2, ...]) |
Excel MAX grein |
MAXA(value1, [value2, ...]) |
Excel MAXA grein |
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
Excel MAXIFS grein |
MEDIAN(value1, [value2, ...]) |
Excel MEDIAN grein |
MIN(value1, [value2, ...]) |
Excel MIN grein |
MINA(value1, [value2, ...]) |
Excel MINA grein |
MINIFS(range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...]) |
Excel MINIFS grein |
PEARSON(data_y, data_x) |
Excel PEARSON grein |
PERCENTILE(data, percentile) |
Excel PERCENTILE grein |
PERCENTILE.EXC(data, percentile) |
Excel PERCENTILE.EXC grein |
PERCENTILE.INC(data, percentile) |
Excel PERCENTILE.INC grein |
POLYFIT.COEFFS(data_y, data_x, order, [intercept]) |
Reiknar stuðla margliðuaðhvarfsgreiningar á gagnasafni (ekki samhæft við Excel) |
POLYFIT.FORECAST(x, data_y, data_x, order, [intercept]) |
Spáir fyrir um gildi með margliðuaðhvarfsgreiningu á gagnasafni (ekki samhæft við Excel) |
QUARTILE(data, quartile_number) |
Excel QUARTILE grein |
QUARTILE.EXC(data, quartile_number) |
Excel QUARTILE.EXC grein |
QUARTILE.INC(data, quartile_number) |
Excel QUARTILE.INC grein |
RANK(value, data, [is_ascending]) |
Excel RANK grein |
RSQ(data_y, data_x) |
Excel RSQ grein |
SMALL(data, n) |
Excel SMALL grein |
SLOPE(data_y, data_x) |
Excel SLOPE grein |
SPEARMAN(data_y, data_x) |
Reiknar Spearman-röðunarfylgistuðul gagnasafns (ekki samhæft við Excel) |
STDEV(value1, [value2, ...]) |
Excel STDEV grein |
STDEV.P(value1, [value2, ...]) |
Excel STDEV.P grein |
STDEV.S(value1, [value2, ...]) |
Excel STDEV.S grein |
STDEVA(value1, [value2, ...]) |
Excel STDEVA grein |
STDEVP(value1, [value2, ...]) |
Excel STDEVP grein |
STDEVPA(value1, [value2, ...]) |
Excel STDEVPA grein |
STEYX(data_y, data_x) |
Excel STEYX grein |
TREND(known_data_y, [known_data_x], [new_data_x], [b]) |
Passar gögn við línulega þróun með minnstu kvaðrata aðferð (ekki samhæft við Excel) |
VAR(value1, [value2, ...]) |
Excel VAR grein |
VAR.P(value1, [value2, ...]) |
Excel VAR.P grein |
VAR.S(value1, [value2, ...]) |
Excel VAR.S grein |
VARA(value1, [value2, ...]) |
Excel VARA grein |
VARP(value1, [value2, ...]) |
Excel VARP grein |
VARPA(value1, [value2, ...]) |
Excel VARPA grein |
Texti
| Heiti og frumbreytur | Lýsing eða tengill |
|---|
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
CHAR(table_number) |
Excel CHAR grein |
CLEAN(text) |
Excel CLEAN grein |
CONCATENATE(string1, [string2, ...]) |
Excel CONCATENATE grein |
EXACT(string1, string2) |
Excel EXACT grein |
FIND(search_for, text_to_search, [starting_at]) |
Excel FIND grein |
JOIN(delimiter, value_or_array1, [value_or_array2, ...]) |
Sameinar stök fylkja með skiltákni (ekki samhæft við Excel) |
LEFT(text, [number_of_characters]) |
Excel LEFT grein |
LEN(text) |
Excel LEN grein |
LOWER(text) |
Excel LOWER grein |
MID(text, starting_at, extract_length) |
Excel MID grein |
PROPER(text_to_capitalize) |
Excel PROPER grein |
REPLACE(text, position, length, new_text) |
Excel REPLACE grein |
RIGHT(text, [number_of_characters]) |
Excel RIGHT grein |
SEARCH(search_for, text_to_search, [starting_at]) |
Excel SEARCH grein |
SPLIT(text, delimiter, [split_by_each], [remove_empty_text]) |
Excel TEXTSPLIT grein |
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) |
Excel SUBSTITUTE grein |
TEXT(number, format) |
Excel TEXT grein |
TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...]) |
Excel TEXTJOIN grein |
TRIM(text) |
Excel TRIM grein |
UPPER(text) |
Excel UPPER grein |
Vefur
| Heiti og frumbreytur | Lýsing eða tengill |
|---|---|
HYPERLINK(url, [link_label]) |
Excel HYPERLINK grein |