Written by Calculates the Macauley modified duration for a security assuming a par value of $100.
Calculates the determinant of a matrix from an array.
Returns the highest value from a range of cells that meet specified conditions.
Returns the highest value from a set of inputs, which can include numbers, text, and boolean values.
Returns the highest value from a set of arguments.
Finds values within a specific range or array
Produces an array where each value from the input array(s) is transformed into a new value by applying a LAMBDA function.
Generates a calculated array with specified dimensions by utilizing a LAMBDA.
Transforms text to lowercase letters.
Searches for values within a vector or matrix.