Find Smallest Number using MIN Function

How to find smallest number using MIN function in OpenOffice Spreadsheet?

Explanation

MIN function is used to find the smallest number from a range of values. The syntax for the MIN function is, MIN(number1; number2; ... number30).
To find out the min value,
Step 1: Select the cell where you need the answer to be displayed.
Step 2: Type =MIN( then drag and select the cells separated by semicolon and close the bracket.
Step 3: Press the "Enter" Key.
Example: If you want to calculate the minimum value for a set of numbers which is in the cell reference A1 to A8, then you have to give it as =MIN(A1:A8)
Min Function in Spreadsheet

Related Topics