MAX, and MIN Functions

To find the maximum (largest) and minimum (smallest) value out of the set of data, we can maximize the use of MAX and MIN function. Before we practice using MAX and MIN functions, let’s gear up our material with the following set of data.

MAX Function returns the largest value in a set of values despite its logical values and text. To use MAX function, type in formula = MAX (number1, number2, …)

Press Enter and the result will be displayed. Do the same for Most Heavy category

MIN Function returns the smallest value in a set of values despite its logical values and text. To use MIN function, type in formula = MIN (number1, number2, …)

Press Enter and the result will be displayed. Do the same for Most Light category.