Error Functions

ERF Function—Error function.

ERFCE Function—Evaluates the exponentially scaled complementary error function.

ERFE Function—Evaluates a scaled function related to ERFC(z).

ERFC Function—Complementary error function.

BETA Function—Beta function.

LNBETA Function—Logarithmic beta function.

BETAI Function—Incomplete beta function.

Gamma Functions

GAMMA Function—Gamma function.

LNGAMMA Function—Logarithmic gamma function.

GAMMAI Function—Incomplete gamma function.

Bessel Functions with Real Order and Complex Argument

BESSI Function—Modified Bessel function of the first kind.

BESSJ Function—Bessel function of the first kind.

BESSK Function—Modified Bessel function of the second kind.

BESSY Function—Bessel function of the second kind.

BESSI_EXP Function—Bessel function e-|x|I0(x), Bessel function     e-|x|I1(x).

BESSK_EXP Function—Bessel function exK0(x), Bessel function exK1(x).

ELK Function—Complete elliptic integral of the first kind.

ELE Function—Complete elliptic integral of the second kind.

ELRF Function—Carlson's elliptic integral of the first kind.

ELRD Function—Carlson's elliptic integral of the second kind.

ELRJ Function—Carlson's elliptic integral of the third kind.

ELRC Function—Special case of Carlson's elliptic integral.

FRESNEL_COSINE Function—Cosine Fresnel integral.

FRESNEL_SINE Function—Sine Fresnel integral.

AIRY_AI Function—Airy function, and derivative of the Airy function.

AIRY_BI Function—Airy function of the second find, and derivative of the Airy function of the second kind.

HERMITE Function—Evaluates Hermite polynomials.

KELVIN_BER0 Function—Kelvin function ber of the first kind, order 0, and derivative of the Kelvin function ber.

KELVIN_BEI0 Function—Kelvin function bei of the first kind, order 0, and derivative of the Kelvin function bei.

KELVIN_KER0 Function—Kelvin function ker of the second kind, order 0, and derivative of the Kelvin function ker.

KELVIN_KEI0 Function—Kelvin function kei of the second kind, order 0 and derivative of the Kelvin function kei.

LEGENDRE Function—Evaluates the associated Legendre functions.

CUM_INTR Function—Evaluates cumulative interest.

CUM_PRINC Function—Evaluates cumulative principal.

DEPRECIATION_DB Function—Evaluates depreciation using the fixed-declining method.

DEPRECIATION_DDB Function—Evaluates depreciation using the double-declining method.

DEPRECIATION_SLN Function—Evaluates depreciation using the straight-line method.

DEPRECIATION_SYD Function—Evaluates depreciation using the sum-of-years digits method.

DEPRECIATION_VDB Function—Evaluates depreciation using the variable declining method.

DOLLAR_DECIMAL Function—Evaluates and converts fractional price to decimal price.

DOLLAR_FRACTION Function—Evaluates and converts decimal price to fractional price.

EFFECTIVE_RATE Function—Evaluates effective rate.

FUTURE_VALUE Function—Evaluates future value.

FUTURE_VAL_SCHD Function—Evaluates future value; considering a schedule of compound interest rates.

INT_PAYMENT Function—Evaluates interest payment.

INT_RATE_ANNUITY Function—Evaluates interest rate.

INT_RATE_RETURN Function—Evaluates internal rate of return.

INT_RATE_SCHD Function—Evaluates internal rate of return for a schedule of cash flows.

MOD_INTERN_RATE Function—Evaluates modified internal rate.

NET_PRES_VALUE Function—Evaluates net present value.

NOMINAL_RATE Function—Evaluates nominal rate.

NUM_PERIODS Function—Evaluates number of periods.

PAYMENT Function—Evaluates periodic payment.

PRESENT_VALUE Function—Evaluates present value.

PRES_VAL_SCHD Function—Evaluates present value for a schedule of cash flows.

PRINC_PAYMENT Function—Evaluates the payment for a principal.

ACCR_INT_MAT Function—Evaluates accrued interest at maturity.

ACCR_INT_PER Function—Evaluates accrued interest periodically.

BOND_EQV_YIELD Function—Evaluates bond-equivalent yield.

CONVEXITY Function—Evaluates convexity.

COUPON_DAYS Function—Evaluates days in a coupon period.

COUPON_NUM Function—Evaluates number of coupons.

SETTLEMENT_DB Function—Evaluates days before settlement.

COUPON_DNC Function—Evaluates days to next coupon date.

DEPREC_AMORDEGRC Function—Evaluates depreciation per accounting period .

DEPREC_AMORLINC Function—Evaluates depreciation.

DISCOUNT_PR Function—Evaluates discount price.

DISCOUNT_RT Function—Evaluates discount rate.

DISCOUNT_YLD Function—Evaluates yield for a discounted security.

DURATION Function—Evaluates duration.

INT_RATE_SEC Function—Evaluates the interest rate of a security.

DURATION_MAC Function—Evaluates Macauley duration.

COUPON_NCD Function—Evaluates next coupon date.

COUPON_PCD Function—Evaluates previous coupon date.

PRICE_PERIODIC Function—Evaluates price per $100 face value periodically.

PRICE_MATURITY Function—Evaluates price per $100 face value at maturity.

MATURITY_REC Function—Evaluates amount received at maturity.

TBILL_PRICE Function—Evaluates Treasury bill's price.

TBILL_YIELD Function—Evaluates Treasury bill's yield.

YEAR_FRACTION Function—Evaluates year fraction.

YIELD_MATURITY Function—Evaluates yield at maturity.

YIELD_PERIODIC Function—Evaluates yield periodically.