Written by Returns the formula from a specified reference as text.
Calculates the annualized interest rate effectively.
Calculates the highest value within a specified range of cells based on defined criteria.
For parameters x, n, m, and a, this function computes the sum of a power series: a1 * x^n + a2 * x^(n+m) + … + ai * x^(n+(i-1)m), where i denotes the count of values within the range ‘a’.
Returns a reference to a cell defined by a text string.
Returns the first argument when it is not an error; otherwise, it yields the second argument if provided, or a blank if the second is not available.
Verifies whether a referenced cell contains a formula.
Determines the total number of days from the settlement date to the upcoming coupon or interest payment date.