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 theExcel Basic Tutorialcolumn!
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!