Excel Formulas to find the Maximum Value if Criteria Match!!
Tags: excelformula, excelformulas
Published: 2021-01-19 10:31:11

---
title: Excel Formulas to find the Maximum Value if Criteria Match!!
published: true
date: 2021-01-19 09:12:48 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-maximum-if-criteria-match/
---

When working with long ranges of data we need to find the max value among the range If the given statement stands True. In this article, we will learn about how to calculate the **Maximum value if the criteria match in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Max if criteria match](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Max-if-criteria-match.png)](https://geekexcel.com/?attachment_id=21182#main)<figcaption id="caption-attachment-21182">Max if criteria match</figcaption>
## Generic Formula:

- To get the maximum value based on certain criteria, you can use the below formula.

**=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(criteria\_range=criteria,value\_range))**

## Syntax Explanations:

- **MAX** – In Excel, the [**MAX function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/) will return the largest numeric value from the range of input values.
- **IF** – This function will help to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result. Read more on the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Value\_range** – It represents the input data given in the worksheet.
- **Criteria\_range** – It is one of the inputs that contain the criteria range.
- **Criteria** – It represents the criteria.

## Practical Example:

Now we are going to see how to find the maximum value in Excel. Refer to the below image.

- Here, we will give the input values in [**Column**](https://geekexcel.com/excel-office-365-columns/) **B** and **Column**  **C**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-14.png)<figcaption id="caption-attachment-21179">Input Ranges</figcaption>

- Then, apply the given formula in the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section based on your input ranges. You can also see the formula in the selected cell.

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-13.png)<figcaption id="caption-attachment-21180">Enter a formula</figcaption>

- Press **CTRL** + **SHIFT** + **ENTER** Keys to get the exact matching value.
- Finally, we will get the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-34.png)<figcaption id="caption-attachment-21181">Result</figcaption>

## Wrap-Up:

Hope you understood the simple formulas used to **find the maximum value if the criteria match in Excel**. Make use of it. Found something that we’ve not covered? Stuck on something? Let me know in the below **comment** section. Click here to know more about **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Get Information Corresponding to Maximum Value!!](https://geekexcel.com/get-information-corresponding-to-maximum-value/)**
- **[Excel Formulas to Get the Maximum Value Based on Criteria!!](https://geekexcel.com/excel-formulas-maximum-value-criteria/)**