Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
369 formule trovate · pagina 2 di 8
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(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(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(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(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(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(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(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(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(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(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(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(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
Finance
Apri schedaSYD(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(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
Finance
Apri schedaVDB(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(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(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(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(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(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 schedaDETECTLANGUAGE(text_or_range)
Identifies the language used in text within the specified range. Learn more
Automazione
Apri schedaGOOGLETRANSLATE(text, [source_language], [target_language])
Translates text from one language into another Learn more
Automazione
Apri schedaIMAGE(url, [mode], [height], [width])
Inserts an image into a cell. Learn more
Automazione
Apri schedaSPARKLINE(data, [options])
Creates a miniature chart contained within a single cell. Learn more
Automazione
Apri schedaCELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Analisi dati
Apri schedaERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Analisi dati
Apri schedaISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Analisi dati
Apri schedaISDATE(value)
Returns whether a value is a date. Learn more.
Analisi dati
Apri schedaISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Analisi dati
Apri schedaISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Analisi dati
Apri schedaISERROR(value)
Checks whether a value is an error. Learn more
Analisi dati
Apri schedaISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Analisi dati
Apri schedaISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Analisi dati
Apri schedaISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Analisi dati
Apri schedaISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Analisi dati
Apri schedaISNUMBER(value)
Checks whether a value is a number. Learn more
Analisi dati
Apri schedaISREF(value)
Checks whether a value is a valid cell reference. Learn more
Analisi dati
Apri schedaISTEXT(value)
Checks whether a value is text. Learn more
Analisi dati
Apri schedaN(value)
Returns the argument provided as a number. Learn more
Analisi dati
Apri schedaNA()
Returns the "value not available" error, `#N/A`. Learn more
Analisi dati
Apri schedaSHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Analisi dati
Apri schedaTYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
Analisi dati
Apri schedaFALSE()
Returns the logical value `FALSE`. Learn more
Produttivita
Apri schedaIFNA(value, value_if_na)
Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
Produttivita
Apri schedaIFS(condition1, value1, [condition2, value2], …)
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
Produttivita
Apri scheda