Formula: =MAX(range)

Description: The MAX function returns the largest value in a range of cells.

Example:

=MAX(A1:A10)

This formula will return the largest value in cells A1 to A10.

Formula: =MIN(range)

Description: The MIN function returns the smallest value in a range of cells.

Example:

=MIN(A1:A10)

This formula will return the smallest value in cells A1 to A10.

Usage:

To use the MAX or MIN function, simply enter the range of cells that you want to find the maximum or minimum value for into the parentheses of the formula. For example, to find the largest value in cells A1 to A10, you would enter the following formula:

=MAX(A1:A10)

To find the smallest value in cells A1 to A10, you would enter the following formula:

=MIN(A1:A10)

You can also use the MAX and MIN functions to find the maximum or minimum value in multiple ranges of cells. To do this, simply separate the ranges with commas. For example, to find the largest value in cells A1 to A10 and B1 to B10, you would enter the following formula:

=MAX(A1:A10, B1:B10)

The MAX and MIN functions are very useful functions for finding the maximum and minimum values in Excel. They can be used in a variety of ways, such as finding the highest and lowest sales figures for a company, the tallest and shortest students in a class, or the largest and smallest number in a set of data.

Here is an example of how to use the MAX function to find the highest sales figure for a company in a given month:

=MAX(C2:C10)

This formula will return the highest value in cells C2 to C10, which contain the sales figures for each day of the month. The result of the formula will be the highest sales figure for the month.

Here is an example of how to use the MIN function to find the lowest temperature for a city in a given week:

=MIN(D2:D8)

This formula will return the smallest value in cells D2 to D8, which contain the temperatures for each day of the week. The result of the formula will be the lowest temperature for the week.

I hope this tutorial is helpful!