IMCSCH
IMCSCH(number)
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.
Automazione
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 3 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
IMDIV
IMDIV(dividend, divisor)
Returns one complex number divided by another. Learn more
Automazione
Apri schedaIMEXP
IMEXP(exponent)
Returns Euler's number, e (~2.718) raised to a complex power. Learn more.
Automazione
Apri schedaIMLOG
IMLOG(value, base)
Returns the logarithm of a complex number for a specified base. Learn more.
Automazione
Apri schedaIMLOG10
IMLOG10(value)
Returns the logarithm of a complex number with base 10. Learn more.
Automazione
Apri schedaIMLOG2
IMLOG2(value)
Returns the logarithm of a complex number with base 2. Learn more.
Automazione
Apri schedaIMPRODUCT
IMPRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of complex numbers together. Learn more
Automazione
Apri schedaIMREAL
IMREAL(complex_number)
Returns the real coefficient of a complex number. Learn more
Automazione
Apri schedaIMSEC
IMSEC(number)
Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.
Automazione
Apri schedaIMSECH
IMSECH(number)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.
Automazione
Apri schedaIMSIN
IMSIN (number)
Returns the sine of the given complex number. Learn more.
Automazione
Apri schedaIMSINH
IMSINH(number)
Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.
Automazione
Apri schedaIMSUB
IMSUB(first_number, second_number)
Returns the difference between two complex numbers. Learn more
Automazione
Apri schedaIMSUM
IMSUM(value1, [value2, ...])
Returns the sum of a series of complex numbers. Learn more
Automazione
Apri schedaIMTAN
IMTAN(number)
Returns the tangent of the given complex number. Learn more.
Automazione
Apri schedaIMTANH
IMTANH(number)
Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.
Automazione
Apri schedaOCT2BIN
OCT2BIN(signed_octal_number, [significant_digits])
Converts a signed octal number to signed binary format. Learn more
Automazione
Apri schedaOCT2DEC
OCT2DEC(signed_octal_number)
Converts a signed octal number to decimal format. Learn more
Automazione
Apri schedaOCT2HEX
OCT2HEX(signed_octal_number, [significant_digits])
Converts a signed octal number to signed hexadecimal format. Learn more
Automazione
Apri schedaFILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaSORT
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
Sorts the rows of a given array or range by the values in one or more columns. Learn more
Analisi dati
Apri schedaSORTN
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Returns the first n items in a data set after performing a sort. Learn more
Analisi dati
Apri schedaACCRINT
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Calculates the accrued interest of a security that has periodic payments. Learn more
Finance
Apri schedaACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
Finance
Apri schedaAMORLINC
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more.
Finance
Apri schedaCOUPDAYBS
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more
Finance
Apri schedaCOUPDAYS
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more
Finance
Apri schedaCOUPDAYSNC
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more
Finance
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
Finance
Apri schedaCOUPNUM
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more
Finance
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
Finance
Apri schedaCUMIPMT
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaCUMPRINC
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaDB
DB(cost, salvage, life, period, [month])
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more
Finance
Apri schedaDDB
DDB(cost, salvage, life, period, [factor])
Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more
Finance
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Finance
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Finance
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
Finance
Apri schedaDURATION
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more
Finance
Apri schedaEFFECT
EFFECT(nominal_rate, periods_per_year)
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more
Finance
Apri schedaFV
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaFVSCHEDULE
FVSCHEDULE(principal, rate_schedule)
Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more
Finance
Apri schedaINTRATE
INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])
Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more
Finance
Apri schedaIPMT
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaIRR
IRR(cashflow_amounts, [rate_guess])
Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more
Finance
Apri schedaISPMT
ISPMT(rate, period, number_of_periods, present_value)
The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.
Finance
Apri schedaMDURATION
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])
Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaMIRR
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more
Finance
Apri scheda