NOMINAL
NOMINAL(effective_rate, periods_per_year)
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more
Finance
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
515 formule trovate · pagina 4 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
NPER
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaNPV
NPV(discount, cashflow1, [cashflow2, ...])
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more
Finance
Apri schedaPDURATION
PDURATION(rate, present_value, future_value)
Returns the number of periods for an investment to reach a specific value at a given rate. Learn more.
Finance
Apri schedaPMT
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPPMT
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPRICE
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaPRICEDISC
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more
Finance
Apri schedaPRICEMAT
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
Calculates the price of a security paying interest at maturity, based on expected yield. Learn more
Finance
Apri schedaPV
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaRATE
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more
Finance
Apri schedaRECEIVED
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more
Finance
Apri schedaRRI
RRI(number_of_periods, present_value, future_value)
Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more.
Finance
Apri schedaSLN
SLN(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
Finance
Apri schedaSYD
SYD(cost, salvage, life, period)
Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more
Finance
Apri schedaTBILLEQ
TBILLEQ(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLPRICE
TBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLYIELD
TBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
Finance
Apri schedaVDB
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Returns the depreciation of an asset for a particular period (or partial period). Learn more.
Finance
Apri schedaXIRR
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more
Finance
Apri schedaXNPV
XNPV(discount, cashflow_amounts, cashflow_dates)
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more
Finance
Apri schedaYIELD
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more
Finance
Apri schedaYIELDDISC
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more
Finance
Apri schedaYIELDMAT
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Calculates the annual yield of a security paying interest at maturity, based on price. Learn more
Finance
Apri schedaARRAYFORMULA
ARRAYFORMULA(array_formula)
Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Learn more
Automazione
Apri schedaDETECTLANGUAGE
DETECTLANGUAGE(text_or_range)
Identifies the language used in text within the specified range. Learn more
Automazione
Apri schedaGOOGLEFINANCE
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Fetches current or historical securities information from Google Finance. Learn more
Automazione Finance
Apri schedaGOOGLETRANSLATE
GOOGLETRANSLATE(text, [source_language], [target_language])
Translates text from one language into another Learn more
Automazione
Apri schedaIMAGE
IMAGE(url, [mode], [height], [width])
Inserts an image into a cell. Learn more
Automazione
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
Apri schedaSPARKLINE
SPARKLINE(data, [options])
Creates a miniature chart contained within a single cell. Learn more
Automazione
Apri schedaCELL
CELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Analisi dati
Apri schedaERROR.TYPE
ERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Analisi dati
Apri schedaISBLANK
ISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Analisi dati
Apri schedaISDATE
ISDATE(value)
Returns whether a value is a date. Learn more.
Analisi dati
Apri schedaISEMAIL
ISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Analisi dati
Apri schedaISERR
ISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Analisi dati
Apri schedaISERROR
ISERROR(value)
Checks whether a value is an error. Learn more
Analisi dati
Apri schedaISFORMULA
ISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Analisi dati
Apri schedaISLOGICAL
ISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Analisi dati
Apri schedaISNA
ISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Analisi dati
Apri schedaISNONTEXT
ISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Analisi dati
Apri schedaISNUMBER
ISNUMBER(value)
Checks whether a value is a number. Learn more
Analisi dati
Apri schedaISREF
ISREF(value)
Checks whether a value is a valid cell reference. Learn more
Analisi dati
Apri schedaISTEXT
ISTEXT(value)
Checks whether a value is text. Learn more
Analisi dati
Apri schedaN
N(value)
Returns the argument provided as a number. Learn more
Analisi dati
Apri schedaNA
NA()
Returns the "value not available" error, `#N/A`. Learn more
Analisi dati
Apri schedaSHEETS
SHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Analisi dati
Apri scheda