Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Financial (55)

=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

Returns the accrued interest for a security that pays periodic interest.

=ACCRINTM(issue, settlement, rate, par, [basis])

Returns the accrued interest for a security that pays interest at maturity.

=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Returns the depreciation for each accounting period by using a depreciation coefficient.

=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Returns the depreciation for each accounting period.

=COUPDAYBS(settlement, maturity, frequency, [basis])

Returns the number of days from the beginning of the coupon period to the settlement date.

=COUPDAYS(settlement, maturity, frequency, [basis])

Returns the number of days in the coupon period that contains the settlement date.

=COUPDAYSNC(settlement, maturity, frequency, [basis])

Returns the number of days from the settlement date to the next coupon date.

=COUPNCD(settlement, maturity, frequency, [basis])

Returns the next coupon date after the settlement date.

=COUPNUM(settlement, maturity, frequency, [basis])

Returns the number of coupons payable between the settlement date and maturity date.

=COUPPCD(settlement, maturity, frequency, [basis])

Returns the previous coupon date before the settlement date.

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

Returns the cumulative interest paid between two periods.

=CUMPRINC(rate, nper, pv, start_period, end_period, type)

Returns the cumulative principal paid on a loan between two periods.

=DB(cost, salvage, life, period, [month])

Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.

=DDB(cost, salvage, life, period, [factor])

Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.

=DISC(settlement, maturity, pr, redemption, [basis])

Returns the discount rate for a security.

=DOLLARDE(fractional_dollar, fraction)

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

=DOLLARFR(decimal_dollar, fraction)

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.

=DURATION(settlement, maturity, coupon, yld, frequency, [basis])

Returns the annual duration of a security with periodic interest payments.

=EFFECT(nominal_rate, npery)

Returns the effective annual interest rate.

=FV(rate, nper, pmt, [pv], [type])

Returns the future value of an investment.

=FVSCHEDULE(principal, schedule)

Returns the future value of an initial principal after applying a series of compound interest rates.

=INTRATE(settlement, maturity, investment, redemption, [basis])

Returns the interest rate for a fully invested security.

=IPMT(rate, per, nper, pv, [fv], [type])

Returns the interest payment for an investment for a given period.

=IRR(values, [guess])

Returns the internal rate of return for a series of cash flows.

=ISPMT(rate, per, nper, pv)

Calculates the interest paid during a specific period of an investment.

=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])

Returns the Macauley modified duration for a security with an assumed par value of $100.

=MIRR(values, finance_rate, reinvest_rate)

Returns the internal rate of return where positive and negative cash flows are financed at different rates.

=NOMINAL(effect_rate, npery)

Returns the annual nominal interest rate.

=NPER(rate, pmt, pv, [fv], [type])

Returns the number of periods for an investment.

=NPV(rate, value1, [value2], ...)

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])

Returns the price per $100 face value of a security with an odd first period.

=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])

Returns the yield of a security with an odd first period.

=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])

Returns the price per $100 face value of a security with an odd last period.

=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])

Returns the yield of a security with an odd last period.

=PDURATION(rate, pv, fv)

Returns the number of periods required by an investment to reach a specified value.

=PMT(rate, nper, pv, [fv], [type])

Returns the periodic payment for an annuity.

=PPMT(rate, per, nper, pv, [fv], [type])

Returns the payment on the principal for an investment for a given period.

=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

Returns the price per $100 face value of a security that pays periodic interest.

=PRICEDISC(settlement, maturity, discount, redemption, [basis])

Returns the price per $100 face value of a discounted security.

=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

Returns the price per $100 face value of a security that pays interest at maturity.

=PV(rate, nper, pmt, [fv], [type])

Returns the present value of an investment.

=RATE(nper, pmt, pv, [fv], [type], [guess])

Returns the interest rate per period of an annuity.

=RECEIVED(settlement, maturity, investment, discount, [basis])

Returns the amount received at maturity for a fully invested security.

=RRI(nper, pv, fv)

Returns an equivalent interest rate for the growth of an investment.

=SLN(cost, salvage, life)

Returns the straight-line depreciation of an asset for one period.

=SYD(cost, salvage, life, per)

Returns the sum-of-years' digits depreciation of an asset for a specified period.

=TBILLEQ(settlement, maturity, discount)

Returns the bond-equivalent yield for a Treasury bill.

=TBILLPRICE(settlement, maturity, discount)

Returns the price per $100 face value for a Treasury bill.

=TBILLYIELD(settlement, maturity, pr)

Returns the yield for a Treasury bill.

=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Returns the depreciation of an asset for a specified or partial period by using a declining balance method.

=XIRR(values, dates, [guess])

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

=XNPV(rate, values, dates)

Returns the net present value for a schedule of cash flows that is not necessarily periodic.

=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])

Returns the yield on a security that pays periodic interest.

=YIELDDISC(settlement, maturity, pr, redemption, [basis])

Returns the annual yield for a discounted security; for example, a Treasury bill.

=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

Returns the annual yield of a security that pays interest at maturity.