But for the MAX MIN value use the MAX function MIN function in excel. You can use this function to select a value based on its relative standing. Or returns the largest value in the array.
For example to select the formula for finding the tangent of an angle you would scroll down and click the TAN option.
In financial analysis the SMALL function can be useful in finding the smallest value. For example the LARGE function can find the first second third or nth smallest value in a list or an array. LARGE A2A8 ROW -1 This function works by using the ROW Function to define the k-value. The Microsoft Excel LARGE function returns the nth largest value from a set of values.