MIN and MAX Functions in MS Excel

MIN and MAX Functions in MS Excel

3 mins read6.1K Views Comment
clickHere
Rashmi
Rashmi Karan
Manager - Content
Updated on Mar 3, 2023 13:31 IST

Learn about MIN and MAX functions in MS Excel in this blog.

2022_03_min-and-max-functions-1.jpg

It is very usual that there is information in different cells and within that information, we want to obtain the minimum or maximum value quickly. The MIN and MAX functions are very interesting functions that allow us to obtain or detect the maximum and minimum value of information from a given data set. In this blog, we will cover how to use MIN and MAX functions in MS Excel.

Content

MIN Function

Excel’s MIN function belongs to the category of statistical functions, and the official definition is that it returns the minimum value from a list of values. Min function ignores empty cells, logical values ​​, and text. 

150+ Keyboard Shortcuts In Excel
150+ Keyboard Shortcuts In Excel
Excel users who enter a lot of data with the keyboard can boost their productivity by learning Excel shortcut keys, which allow them to access the program’s commands much faster....read more
How to Use Excel Filter Shortcut?
How to Use Excel Filter Shortcut?
Excel Filter shortcuts are keyboard combinations that you can use to apply filters to your data quickly and easily. The article will explain different ways to use Excel Filter shortcuts,...read more

MIN Syntax

=MIN(number1, [number2], …)

How to use Excel’s MIN function?

We take the below spreadsheet as an example. This is a list of some of the sub-verticals of some startups and their valuation. Here we have to find the lowest amount.

How to Create a MIN Formula?

  • Click on the cell where you want to add the formula
  • Click the AutoSum button list arrow
  • Select MIN
  • You will get the minimum value from the specified range when you click on MIN.
  1. The MIN formula =MIN(B2:B18) – suggesting the range of cell numbers B2 to B18
  2. The minimum value in the data set
  3. The resultant value from the specified range after you apply the formula
What Are Excel Errors and How To Fix Them?
What Are Excel Errors and How To Fix Them?
Excel is a powerful tool for working with data, but it can also be frustrating when errors occur. While some errors are easy to fix, others can be more difficult...read more
Introduction to MS Excel – A Beginner’s Guide
Introduction to MS Excel – A Beginner’s Guide
Microsoft Excel has been around for decades and is one of the most desired skills if you are considering a career in data science or analysis. But there are still...read more

MAX Function

The Excel MAX Formula finds the maximum value from a given data/array/database set. MAX function returns the highest value from that set. It counts numbers and ignores empty cells, text, logical, and text values. 

MAX Syntax

=MAX(number1, [number2], …)

How to Create a MAX Formula?

  • Click on the cell where you want to add the formula
  • Click the AutoSum button list arrow
  • Select MAX

Again we refer to the same set of data. We select the data, go to Autosum, and hover to the max function.

  • After you click on MAX, you will get the maximum value from the specified range.
  1. The MIN formula =MAX(B2:B18) – suggesting the range of cell numbers B2 to B18
  2. The minimum value in the data set
  3. The resultant value from the specified range after you apply the formula

I hope you learn how to use the MAX and MIN functions in MS Excel. Next, we will cover other essential MS Excel functions like  SUM, AVERAGE, MEDIAN, COUNT, etc. 


Top Trending Articles in MS Excel:

Most Useful Excel Formulas | Min Max Functions in Excel | Average Functions in Excel | Introduction to MS Excel | Financial Modelling in Excel | MS Excel interview questions | Sum Function in Excel | Trim Function in Excel | Pivot Table in Excel | Percentage in Excel | Vlookup in Excel | Median Function in Excel | Types of Charts in Excel | Count Function in Excel | MS Excel Vs. Google Sheet | Remove Duplicates in Excel | Create Graph in Excel

FAQs

How to use MAX and MIN functions in Excel

Click in the cell where you want to add the formula. Click the arrow on the Sum button. Select MAX. If necessary click on the desired range of cells. Click the Enter button or press Enter

What is the function of MIN in Excel?

MIN function in Excel returns the minimum value of a set of values.

What is the Max function in Excel?

Max function in Excel returns the maximum value of a set of values.

Why do we use Min and Max in Excel?

The MAX function allows you to find the highest number in a given range. The MIN function does the opposite, providing you with the lowest number in a defined range.

How do you remove the max and min function in Excel?

To remove any formula, be it max or min functions in Excel - Select the cell or range of cells that contain the max or min formula. Press Delete.

About the Author
author-image
Rashmi Karan
Manager - Content

Rashmi is a postgraduate in Biotechnology with a flair for research-oriented work and has an experience of over 13 years in content creation and social media handling. She has a diversified writing portfolio and aim... Read Full Bio

Comments