What is the function to get the minimum value in excel

The minimum function in excel is the min function

The syntax is: MIN(number1, number2, ...)

Note:

1. The parameters number1, number2, etc. can be numbers, cell names, continuous cell ranges, logical values;

2. If it is a cell name, continuous cell range and other data references, usually only the numerical value or the numerical part calculated by the formula is calculated, and the logical value and other contents are not calculated;

3. If min There are no numbers in the parameters after the function, and 0 will be returned.

Example:

Enter the function [=MIN(B2:B10)] in the minimum value column, It means to calculate the minimum value from cell B2 to cell B10.

Press Enter to confirm, you can see that the minimum value has been calculated.

Recommended learning: Excel Basic Tutorial

The above is the detailed content of What is the function to get the minimum value in excel. For more information, please follow other related articles on the PHP Chinese website!