Max and Min functions - Functions for maximum and minimum values ​​in Excel

The Max and Min functions are two frequently used functions in Excel, to return the largest, smallest value of an argument or range of data containing numbers. These 2 functions are very simple to use, and bring high efficiency, if you do not understand the syntax as well as how to use the Max and Min functions, please refer to the following article:

How to use the Max function for maximum value in Excel

Syntax of Max function

MAX (number 1, number 2 ...)

Where: Number 1, number 2 are the arguments or data ranges.

Max function example

Calculate the highest average score of Math in the table below:

Applying the Min function will have the following formula: D15 = MIN (D4: D13) . The result is: 9.

Max and Min functions - Functions for maximum and minimum values ​​in Excel

How to use the Min function for the smallest value in Excel?

Min function syntax

MIN (number 1, number 2 ...)

Where: Number 1, number 2 are the arguments or data ranges.

Min function example

Find the lowest average grade of Math in the table below:

Apply the formula to the resulting cell D16 as follows: D16 = MAX (D4: D13) . The result will be: 4.

Max and Min functions - Functions for maximum and minimum values ​​in Excel

Note:

  • If the argument list does not contain numbers, the Min and Max functions return a value of 0.
  • If the argument is an array or reference, only numbers in that array or reference are used. And empty cells, logical values, or text are ignored.
  • Arguments that are text or error values ​​that are not converted to numbers are error functions.
  • Logical values ​​and numeric values ​​entered directly into the argument list are calculated.

So you all know how to use the Min and Max functions in Excel already. While using Excel, you can also use the Index function to return values ​​in an array.

I wish you successful implementation!

Sign up and earn $1000 a day ⋙

Leave a Comment

Why Checkbox is an underutilized Excel feature?

Why Checkbox is an underutilized Excel feature?

On the surface, Excel Checkboxes seem like a very simple feature - which is probably why they are often overlooked.

Why Excel is the only project management tool you need?

Why Excel is the only project management tool you need?

Many people have tried many project management tools, but still come back to Excel for project management. While it may not be perfect for everyone, it is a simple, yet effective solution that you already know how to use.

Microsoft allows users to use Office applications on Windows for free, but with some limitations.

Microsoft allows users to use Office applications on Windows for free, but with some limitations.

Microsoft recently raised the price of its Microsoft 365 subscription, justifying the change by adding more AI experiences to the service.

TRUNC Function: How to remove decimals and shorten numeric values

TRUNC Function: How to remove decimals and shorten numeric values

There are different ways in Excel to remove decimals and shorten numeric values. In this article, Quantrimang.com will explain how to use the TRUNC function and point out what makes it different from other techniques.

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.

How to Export Airtable to Excel and Google Sheets

How to Export Airtable to Excel and Google Sheets

Airtable lets you create and share relational databases easily. Export your Airtable data to Google Sheets or Excel to enjoy the benefits of advanced charts and data visualization.

Effective ways to use ChatGPT in Excel

Effective ways to use ChatGPT in Excel

Curious about how ChatGPT can enhance your Excel experience? Here are some tips for using ChatGPT in Excel.

How to use the WORKDAY function in Microsoft Excel

How to use the WORKDAY function in Microsoft Excel

In Microsoft Excel, the WORKDAY function is a date and time function and its purpose is to return the date before and after the specified number of working days. Working days do not include weekends or any days defined as holidays.

Why are so many people stopping using Google Sheets and going back to Excel?

Why are so many people stopping using Google Sheets and going back to Excel?

For a while, Google Sheets lured people away from Excel. But many people came back after realizing that Google Sheets is far from beating Excel.

How to use the TREND function in Excel

How to use the TREND function in Excel

You can calculate and visualize trends in Excel using the TREND function. Here's how to use the TREND function in Microsoft Excel.

How to enable and disable macros on Excel

How to enable and disable macros on Excel

The following article will guide readers how to enable and disable macros in Excel 2007, 2010, 2013 and 2016.

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

Latest Huyen Tuong 3Q Code and how to enter code

Latest Huyen Tuong 3Q Code and how to enter code

The latest Huyen Tuong 3Q Code is dedicated to players and supports new players when they first join the 3Q battlefield with the most necessary items.

Fiora DTCL: Standard build for Fiora Demacia Challenger

Fiora DTCL: Standard build for Fiora Demacia Challenger

This season 9.5 of Truth Arena Fiora will definitely replace Yasuo in the 4-gold Challenger main position.

Why propose on one knee?

Why propose on one knee?

Medieval knights (and Game of Thrones' Jon Snow) were famous for kneeling, which may have influenced today's marriage proposals. Here's why men get down on their knees to propose.

Positive quotes, happy status, short optimistic and positive status

Positive quotes, happy status, short optimistic and positive status

Which cheerful and optimistic status helps you lift your spirits the most? This article will summarize for you short, meaningful and cheerful statuses to quickly regain your spirits.

Health risks of Vitamin B12 deficiency

Health risks of Vitamin B12 deficiency

Your red blood cells, nerves, and brain all depend on vitamin B12. But some people don't get enough of this nutrient, and a vitamin B12 deficiency can cause a number of health problems.

What happens to your body if you wear a bra every day?

What happens to your body if you wear a bra every day?

Aside from providing the foundation for your outfit and making you look better, bras are also designed to benefit you in a variety of other ways.

ChatGPT crashes globally

ChatGPT crashes globally

On the morning of November 22, OpenAI's ChatGPT chatbot experienced widespread problems, and many users around the world were unable to use this AI application.

How to Use WiFi Analyzer to Boost Your Wi-Fi Connection

How to Use WiFi Analyzer to Boost Your Wi-Fi Connection

Just buying a new Wi-Fi router isn't enough to boost your network. To get the most out of your Wi-Fi, you need to make sure you're getting the best range, signal, and frequency.

Ways the body communicates with us that are often overlooked

Ways the body communicates with us that are often overlooked

Our bodies are machines, constantly sending signals and messages, but we rarely pay attention to them. Let's see what our bodies want to tell us through the signals below.

The tallest land animals in the world

The tallest land animals in the world

What is the tallest animal in the world? This article will summarize for you the largest animals on land.

Basic units of measurement in computers

Basic units of measurement in computers

Bit stands for Binary Digit, which is the term for the smallest part of computer memory that can store one of two information states: 0 or 1 (which can be understood as the on or off state of a transistor in a computer).

How to Improve Your Note-Taking Habits with Reminders

How to Improve Your Note-Taking Habits with Reminders

A good memory habit starts with reminders—they come at the right time to capture those fleeting thoughts.

7 Free Apps That Will Instantly Improve Your Smartphone Photos

7 Free Apps That Will Instantly Improve Your Smartphone Photos

There are still plenty of free and powerful photography tools you can use to enhance your photos.

Tricks to make Google Search widget more useful

Tricks to make Google Search widget more useful

The Google Search widget gives you quick access to Google Search and the Discover feed, along with Voice Search and Google Lens.

How to log in and turn off password expiration reminder

How to log in and turn off password expiration reminder

If you encounter the message Your password has expired and must be changed on the Windows login screen, it's because passwords for Windows local accounts expire every 42 days by default.