Excel Formulas to Find the Minimum Value From a Range!!
Tags: excelformula, excelformulas
Published: 2020-12-15 09:19:08

---
title: Excel Formulas to Find the Minimum Value From a Range!!
published: true
date: 2020-12-14 10:46:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-minimum-value/
---

When you open your worksheet, there are lots of data in the cells, if you want to look for the minimum data and It is tedious and time-consuming for you to pick up it one by one, then how could you solve it quickly? Here we will show the easiest way to find the **minimum value from a set of data in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to find the minimum value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-minimum-value.png)](https://geekexcel.com/excel-formulas-find-minimum-value/formulas-to-find-the-minimum-value/#main)<figcaption id="caption-attachment-19587">Formulas to find the minimum value</figcaption>
## General Formula:

- To find the minimum value in Excel, use the below formula.

**=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(range)**

## Explanations for Syntax:

- **MIN** – In Excel, the **[MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)** returns the smallest numeric value from the range of input values.
- **Range** – It represents the input range.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Now, we are going to find the minimum value from a set of data.
- Refer to the below image.
- Here, we will give the input values in **Column C** to **Column G**.
- Then, enter the given formula in the selected area.
- Finally, we will get the result in **Cell I3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-51.png)<figcaption id="caption-attachment-19586">Example</figcaption>

## Verdict:

From this tutorial, you can easily understand the simple formulas to find **minimum value from a set of data in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. For more updates keep in touch with our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Limit a Percentage Between 0 and 100!!](https://geekexcel.com/excel-formulas-to-limit-a-percentage-between-0-and-100/)**
- **[Excel Formulas to Get the Largest Value with Criteria!!](https://geekexcel.com/excel-formulas-to-get-the-largest-value-with-criteria/)**
- **[Formulas to Sum the Values from Every Nth Column!!](https://geekexcel.com/wp-admin/post.php?post=18084&action=edit)**
- **[Excel Formulas to Find the Maximum Value from a Set of Numbers!!](https://geekexcel.com/excel-formulas-maximum-value-from-numbers/)**

### Video Tutorial:

<video id="video-19584-4" width="770" height="512" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/webm" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/S9gwlass6k.webm?_=4"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/S9gwlass6k.webm">https://geekexcel.com/wp-content/uploads/2020/12/S9gwlass6k.webm</a></video>