What is the formula for maximum and minimum values ​​in Excel?

Maximum value function: =MAX (start cell: end cell), minimum value function: =MIN (start cell: end cell). (Function names MAX and MIN must be capitalized).

The usage method is as follows:

1. Maximum value function MAX

1. While editing Enter = first in the column, and = must be entered first for each function, then enter the function MAX (must be capitalized). The input range in the function is as shown below:

2. Press Press Enter to confirm. The maximum value is as follows:

2. Minimum value function MIN

1. Minimum value and maximum value The values ​​are similar. Also enter = first in the edit bar, then enter the function MIN (in uppercase letters). Enter the range in the function as shown below:

2. Press Enter to confirm. , the minimum value is as follows:

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of What is the formula for maximum and minimum values ​​in Excel?. For more information, please follow other related articles on the PHP Chinese website!