Written by Computes the total interest paid over a specified number of payment periods for an investment, utilizing fixed periodic payments and a stable interest rate.
Determines the total number of coupon payments, or interest disbursements, from the settlement date to the investment’s maturity date.
Determines the total number of days in the coupon or interest payment period that includes the specified settlement date.
Sorts the rows of a specified array or range based on the values in one or more columns.
Calculates the hyperbolic tangent for the specified complex number. For instance, for a complex input of “x+yi”, it computes “tanh(x+yi)”.
Calculates the secant of a specified complex number. For instance, the complex number “x+yi” yields “sec(x+yi).”
Yields the real part of a complex number.
Calculates the product of a range of complex numbers by multiplying them together.
Calculates the hyperbolic cosecant of a specified complex number. For instance, inputting “x+yi” yields “csch(x+yi)” as a result.
Calculates the hyperbolic cotangent of a specified complex number. For instance, for the complex number “x+yi”, it computes “coth(x+yi)”.