Home • Categories • Questions

How to find the minimum value in a range of cells with the MIN function in Google Sheets?

To find the minimum value in a range of cells using the MIN function in Google Sheets, you can follow these steps:

  1. Open your Google Sheets document or create a new one.
  2. Select an empty cell where you want to display the minimum value from the range.
  3. Type the following formula: =MIN(range).
    • "range" refers to the range of cells you want to find the minimum value in. For example, if you want to find the minimum value in cells A1 to A10, the formula would be =MIN(A1:A10).
  4. Press Enter.

The cell containing the formula will now display the minimum value from the specified range.