Excel MIN and MAX in the Same Formula: Examples and Tips

Yes. In Excel for Microsoft 365 on Windows, you can calculate both endpoints in one formula, such as =MIN(A2:A5)&" to "&MAX(A2:A5), which displays the minimum and maximum together as text. If you need two separate numeric results instead, use MIN and MAX in two cells or return both with a dynamic array formula.

What “in the same formula” can mean

The best formula depends on what you want to do with the answer. A single-cell summary is convenient for a label, report, or dashboard, but joining the values with words turns the result into text. Text that looks like a number cannot be used as a number in every calculation or charting situation.

If you want to keep both results numeric, put the minimum and maximum in separate cells or use a formula that spills into two neighboring cells. Those approaches make it easier to format each value, refer to one endpoint later, or use the results in additional calculations. The key distinction is not whether MIN and MAX can appear together—they can—but whether the output should be a readable label or numeric data.

MIN returns the smallest number in its arguments, while MAX returns the largest. Both can evaluate the same range, so you do not need to sort the data first. The functions do not change the source values.

Combine the minimum and maximum in one cell

Suppose cells A2:A5 contain 12, 18, 7, and 25. With those values in A2:A5, enter this formula to show the two endpoints in one cell:

=MIN(A2:A5)&" to "&MAX(A2:A5)

The displayed result is 7 to 25. The ampersand joins text and values into one text string; the words and spaces inside quotation marks are the separator. You can change the separator to a dash, comma, or label. With the same values in A2:A5, this version produces a label:

="Low: "&MIN(A2:A5)&" | High: "&MAX(A2:A5)

Its result is Low: 7 | High: 25. This can be useful in a chart title or a short status cell. Keep in mind that a formula-generated label is still text even though it contains digits. For instance, another formula that needs the maximum should refer to MAX directly or to a cell containing a numeric MAX result, not to the combined label.

Keep both results numeric

For analysis, a reliable option is to calculate the endpoints in two cells. With the values in A2:A5, enter the minimum formula in B2:

=MIN(A2:A5)

With the same source range, enter the maximum formula in C2:

=MAX(A2:A5)

B2 returns 7 and C2 returns 25; each result remains numeric. You can apply number formats independently or reference either result in another formula. This layout is usually the clearest choice when the values feed a chart, calculation, or later report.

Microsoft 365 also supports a single formula that returns two adjacent numeric results. With the values in A2:A5 and an empty cell such as B2 selected, enter:

=HSTACK(MIN(A2:A5),MAX(A2:A5))

The results spill across B2:C2: 7 in B2 and 25 in C2. HSTACK combines its arguments horizontally, while MIN and MAX calculate the values. The formula must have room to spill; if a cell in the output area is occupied, Excel displays a spill error. HSTACK is available in Microsoft 365 and Excel 2024, but not in every older Excel release. If it is unavailable, use two separate formulas.

Find extremes that meet a condition

Sometimes the real question is not the overall low and high, but the low and high for one group—for example, the sales range for a particular region. MINIFS and MAXIFS calculate extremes while applying criteria. Suppose A2:A6 contains region names and B2:B6 contains corresponding sales values: North, South, North, East, and North in column A, with 12, 9, 18, 14, and 7 in column B.

With regions in A2:A6 and sales in B2:B6, use this formula to find the lowest North sales:

=MINIFS(B2:B6,A2:A6,"North")

The result is 7. With the same layout, use this formula to find the highest North sales:

=MAXIFS(B2:B6,A2:A6,"North")

The result is 18. To display both conditional endpoints in one cell, with that same layout, combine the two functions:

=MINIFS(B2:B6,A2:A6,"North")&" to "&MAXIFS(B2:B6,A2:A6,"North")

The result is 7 to 18. MINIFS and MAXIFS are available in Excel 2019 and later, including Microsoft 365. For a different criterion, replace North with another region name or refer to a cell containing the criterion. If criteria refer to dates or text, ensure the criteria range aligns row by row with the values being evaluated.

Format decimals, dates, and labels

When Excel joins a numeric result to text, it may not display the number in the exact format you want. For example, a value with decimal places might appear with more digits than a report requires. Use TEXT around each endpoint when the output is specifically a text label. Suppose A2:A5 contains decimal measurements; with those values in A2:A5, this formula shows two decimal places:

=TEXT(MIN(A2:A5),"0.00")&" to "&TEXT(MAX(A2:A5),"0.00")

TEXT applies a number format and returns text. The format code 0.00 displays two digits after the decimal point, including trailing zeroes. If the calculated endpoints are 1.2 and 3.456, the label reads 1.20 to 3.46. Choose a format appropriate to the data; rounding for display does not change the underlying values, but the joined label no longer stores them as numeric results.

Dates are stored by Excel as serial numbers, so concatenating a date-based MIN or MAX result can show a serial number rather than a familiar date. With valid Excel dates in A2:A5, format each endpoint using TEXT:

=TEXT(MIN(A2:A5),"m/d/yyyy")&" to "&TEXT(MAX(A2:A5),"m/d/yyyy")

This displays the earliest and latest dates as a readable range. The exact date appearance depends on the format code you choose. If you need to perform date arithmetic afterward, keep the MIN and MAX results numeric in separate cells and apply a date format to those cells instead.

What MIN and MAX include

With a range reference such as A2:A5, MIN and MAX evaluate numeric values in the referenced cells. Blank cells and text in referenced cells are ignored, so a note such as “pending” will not become the minimum or maximum. Numbers stored as text can also be overlooked in a referenced range; if a result seems wrong, check whether the apparent numbers are actually numeric values.

Zero is a number, not a blank. If a range contains zero, MIN can return zero even when the other values are positive. That may be correct for a measurement or sales figure, but it can be surprising when zero means “not entered” in the way a worksheet is being used. Decide how missing or placeholder values should be represented before relying on an extreme.

Error values in the evaluated range can cause a MIN or MAX formula to return an error rather than a number. Also, if there are no numeric values in the referenced range, MIN and MAX return 0. That behavior can make an empty or text-only dataset look like it has a genuine zero endpoint. Check that the range contains the intended numeric data, especially when rows are added or removed.

Common problems and fixes

The answer appears as a number like 45200. The source may contain dates, which Excel stores as serial numbers. Keep the results numeric and apply a date format, or use TEXT with a date format when creating a text label.
The combined result cannot be used in arithmetic. Joining values with an ampersand makes text. Calculate MIN and MAX separately, or use HSTACK when two numeric outputs are needed.
The formula returns zero unexpectedly. Check whether the range has numeric values and whether blanks, text, or numbers stored as text are affecting the result. A range with no numeric values returns 0.
The HSTACK formula shows a spill error. Clear the cells to the right of the formula where the results need to appear. A spill formula cannot place its output over existing cell contents.
The displayed decimal precision looks wrong. Use TEXT for a fixed display inside a text label, or format the numeric result cells without converting them to text.

Choose the right approach

Use a joined formula when the goal is a compact, readable summary and you do not need the output as a number. Use two formulas when you want maximum compatibility and independent numeric values. Use HSTACK when you want one formula to return both numeric values side by side and your Excel version supports it.

For a reusable report, consider whether the range will grow. A fixed reference such as A2:A5 will not automatically include data added below row 5. An Excel Table can expand as records are added, and structured references can make formulas easier to read. For example, a table named Measurements with a column named Reading can be referenced by MIN and MAX. Check the table and column names in your workbook before using structured references; they must match exactly.

There is no need to sort the data to find either endpoint. Sorting changes the order of the source rows, whereas MIN and MAX simply calculate from the values in the specified range. If you want to identify which record holds the minimum or maximum, that is a different task: MIN or MAX returns the value, not its associated name or row.

Frequently Asked Questions

Can MIN and MAX be used in one Excel formula?
Yes. Put both functions in one expression. If you join their results with text, the output is text; if you use HSTACK in a supported version, the formula can return two numeric values in adjacent cells.

How do I show the minimum and maximum in one cell?
With the values in A2:A5, use =MIN(A2:A5)&" - "&MAX(A2:A5). It displays the low and high separated by a dash, but the result is a text label.

How can I return both values without turning them into text?
With the source values in A2:A5, Microsoft 365 or Excel 2024 can use =HSTACK(MIN(A2:A5),MAX(A2:A5)) to spill two numeric results horizontally. In older versions, use MIN and MAX in separate cells.

Can I find the minimum and maximum for one category?
Yes. Use MINIFS and MAXIFS with the values range, criteria range, and criterion. These functions return the lowest and highest values that meet the condition, rather than the overall endpoints.

Why does my combined formula show a date serial or too many decimals?
Concatenation does not preserve a cell’s number format. Use TEXT to format values inside a text label, or keep the results numeric in separate cells and format those cells directly.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.