Microsoft 365 includes premium Word, Excel, and PowerPoint apps, 1 TB cloud storage in OneDrive, advanced security, and more, all in one convenient subscription. With Microsoft 365, you get features as soon as they are released ensuring you’re always working with the latest. Create, view, edit, and share your spreadsheets using Excel for Mac. MIN and MAX Functions: Click the cell where you want to place a minimum or maximum value for a given range. Click the Sum button list arrow on the Home tab and select either Min or Max. Enter the cell range you want to reference, and press Enter. COUNT Function: Click the cell where you want to place a count of the number of cells in.

  1. How To Use Max Function
  2. Excel For Mac Tutorial
  3. Excel Max Function With Condition
  4. Format Cell In Excel For Max Value In A Range

This Excel tutorial explains how to use the Excel MAX function with syntax and examples.


The Microsoft Excel MAX function returns the largest value from the numbers provided.

The MAX function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MAX function can be entered as part of a formula in a cell of a worksheet.


The syntax for the MAX function in Microsoft Excel is:

Parameters or Arguments

It can be a number, named range, array, or reference to a number.
number2, ... number_n
Optional. These are numeric values that can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.

Applies To

  • Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Example (as Worksheet Function)

Let's look at some Excel MAX function examples and explore how to use the MAX function as a worksheet function in Microsoft Excel:

Based on the Excel spreadsheet above, the following MAX examples would return:

Frequently Asked Questions

Question: In Microsoft Excel, I want to calculate the largest yearly difference in total between any adjacent year for each company. Below is my spreadsheet with a small sample of 4 years of data.

Right now, I'm using the following formula to calculate the yearly difference:

I am wondering if there is a way to streamline this and not have such a long and complicated formula.

How To Use Max Function

Answer: Yes, it should be possible to simplify your formula and achieve the same results. By using the ABS function, you could remove some of your IF conditions since you are really looking for the yearly differences as 'absolute values'. Try replacing your formula with the following:

As you can see in the spreadsheet below, this formula is much simpler and returns the same results.

Question:I'm having a problem finding a specific formula in Excel.

Is there a formula that will tell me the Cell with the highest number rather than tell me the highest number? I.E. if K2 has 15 and is the highest, how do I make a formula that says K2 instead of 15?

Excel For Mac Tutorial


Answer: You can use the CELL, INDEX, and MATCH functions in combination with the MAX function to return the cell with the highest value.

Excel Max Function With Condition

Excel For Max

For example, if you wanted to find the cell with the highest value in the range K1 to K10, you could use the following formula:

Format Cell In Excel For Max Value In A Range

This would return the result as an absolute reference such as $K$2, as you stated in your example where the cell K2 contained 15 which was the highest value.

Coments are closed

Top Posts

  • Red Giant Complete Suite Download
  • Apple 10.12 6
  • Fonelab Android Data Recovery Torrent
  • Bookreader Mac App
  • Logic Pro Para Windows Descargar Gratis

Scroll to top