To make sure that all the formulas return the identical result, we will test them on the same set of data. When you wish to get the maximum value based on conditions, there are several formulas for you to choose from. In the internal Excel system, dates are nothing else but serial numbers, so the MAX function handles them without a hitch.įor instance, to find the latest delivery date in C2:C7, make a usual Max formula that you'd use for numbers:

After selecting the last item, release Ctrl and type the closing parenthesis.Įxcel will use an appropriate syntax automatically, and you will get a formula similar to this:Īs shown in the screenshot below, the formula returns the maximum sub-total value from rows 5 and 9:.

After you've typed the opening parenthesis, hold down the Ctrl key and select the cells and ranges in the sheet.The following steps will help you to do that quickly and flawlessly: To make a MAX formula for non-contiguous cells and ranges, you need to include a reference to each individual cell and/or range.

For example, to get the highest value in the range C2:E7, use this simple formula:įind highest value in non-adjacent cells or ranges A range can contain as many rows and columns as you desire. To extract the largest number in a group of numbers, supply that group to the MAX function as a range reference.

In many cases, there are a few different solutions for the same task, so I encourage you to test all the formulas to choose the one best suited for your data type. How to use MAX function in Excel – formula examplesīelow you will find a few typical uses of the Excel MAX function. In references, logical and text values are ignored. Logical values and text representations of numbers supplied directly in the list of arguments are processed (TRUE evaluates as 1, FALSE evaluates as 0).If the arguments contain one or more error values, an error is returned.If the arguments do not contain a single number, the MAX function returns zero.In the current versions of Excel, a MAX formula can accept up to 255 arguments.To successfully use Max formulas your worksheets, please remember these simple facts: This will insert a ready-to-use formula in a cell below the selected range, so please make sure there is at least one blank cell underneath the list of numbers that you've selected: (Or click AutoSum > Max on the Formulas tab in the Function Library group.) On the Home tab, in the Formats group, click AutoSum and pick Max from the drop-down list.If your numbers are in a contiguous row or column (like in this example), you can get Excel to make a Max formula for you automatically. Press the Enter key to complete your formula.įor example, to work out the largest value in the range A1:A6, the formula would go as follows:.

Select a range of numbers using the mouse.

The fastest way to build a Max formula that finds the highest value in a range is this: For the most part, you will deal with ranges and cells. In practice, it's quite a rare case when numbers are 'hardcoded'. To create a MAX formula in its simplest from, you can type numbers directly in the list of arguments, like this: The MAX function is available in all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and lower. Number1 is required, number2 and subsequent arguments are optional. Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.

Absolute value z score calculator