In our day to day life, we feel the necessity of finding the highest value as well as the lowest value. We even need to find out a specifically positioned value. For this purpose, we can use the **MAX,** **MAXA**, and **LARGE **functions to find the largest value. On the other hand, we can use the **MIN**, **MINA**, and **SMALL** functions to find the smallest value. In this article, I am going to show a comparison among **MAX vs MAXA vs LARGE** and **MIN vs MINA vs SMALL** functions in Excel. I hope it will be helpful for you.

## Download Practice Workbook

## Introduction of MAX, MAXA, LARGE, MIN, MINA, and SMALL Functions

### 1. MAX Function

**MAX** function in Excel is used to return the maximum value from a given range of cells. It only applicable for numerical values.

__Syntax__:

`=MAX(number1,[number2],...)`

Argument | Required/Optional | Explanation |
---|---|---|

number1 |
Required | the first number to evaluate |

number2 |
Optional | one can list up to 255 additional numbers, for evaluation |

For more simplification, I have taken a dataset of examination marks. I want to find the highest marks.

** Steps**:

- Simply apply the following equation to find the highest value using the
**MAX**function:

`=MAX(D5:D9)`

Here, the **MAX function **runs through the cells **D5:D9 **and returns the highest value.

- Now, press
**ENTER**to have the result.

Thus, we can find out the highest value.

### 2. MAXA Function

If one is using references that contain logical values or text representations of numbers then it is best to use the **MAXA Function**. The **MAXA** function also returns the largest value from a list of values provided, however, the **MAXA **Function can incorporate numbers, text representations of numbers, and logical values. It considers **TRUE **as **1 **and **FALSE **as **0**.

__Syntax__:

`=MAXA(number1,[number2],...)`

Argument | Required/Optional | Explanation |
---|---|---|

number1 |
Required | the first number/argument to evaluate |

number2 |
Optional | one can list up to 255 additional numbers/arguments, for evaluation |

In this case, I have considered several rows of data including number and arguments.

** Steps**:

- Input the following equation to find the highest value using the
**MAXA**function:

`=MAXA(B5:D5)`

Here, the **MAXA function **runs through the cells **B5:D5 **and returns the highest value.

- Press
**ENTER**to have the highest value.

- Use
**Fill Handle**to**AutoFill**the rests.

### 3. LARGE Function

The **LARGE Function** returns the** k-th** largest value in a list of values. One can use this function to return the first largest value (the same value the **MAX **Function would return) or the second largest value in a data set or the third largest value in a data set and so on.

__Syntax__:

`=LARGE(array,k)`

Argument | Required/Optional | Explanation |
---|---|---|

array |
Required | The array of data to evaluate |

k |
Required | The position from the largest value which one wants to return |

I have taken a dataset of examination marks to explain the **LARGE **function. I want to find the **third highest** marks.

** Steps**:

- First of all, input the following equation to find the third highest value using the
**LARGE**function:

`=LARGE(D5:D9,3)`

Here, the **LARGE function **runs through the cells **D5:D9 **and returns the third highest value as I mentioned the position from the highest value by **3**.

- At the end, hit the
**ENTER**button to have the third highest value.

You can find any place’s value just by changing the value of **k**.

### 4. MIN Function

The **MIN Function** returns the smallest or minimum value of a set of values. It is only applicable for numerical values.

__Syntax__:

`=MIN(number1,[number2],...)`

Argument | Required/Optional | Explanation |
---|---|---|

number1 |
Required | the first number to evaluate |

number2 |
Optional | one can list up to 255 additional numbers, for evaluation |

To explain the process, I have taken a dataset of examination marks. I want to find the lowest marks.

** Steps**:

- Apply the following equation to find the lowest value using the
**MIN**function:

`=MIN(D5:D9)`

Here, the **MIN function **runs through the cells **D5:D9 **and returns the lowest value.

- To get the lowest value in that range, press
**ENTER**.

### 5. MINA Function

The **MINA Function** also returns the smallest value from a list of values provided. It can incorporate numbers, text representations of numbers, and logical values. Similar to the **MAXA **function, it considers **TRUE **as **1 **and **FALSE **as **0**.

__Syntax__:

`=MINA(number1,[number2],...)`

Argument | Required/Optional | Explanation |
---|---|---|

number1 |
Required | the first number/argument to evaluate |

number2 |
Optional | one can list up to 255 additional numbers/arguments, for evaluation |

** Steps**:

- Firstly, apply the following equation to find the lowest value using the
**MINA**function:

`=MINA(B5:D5)`

Here, the **MINA function **runs through the cells **B5:D5 **and returns the lowest value.

- Press
**ENTER**to get the lowest value.

**AutoFill**the remaining cells.

### 6. SMALL Function

The **SMALL Function** returns the** k-th** smallest value in a list of values. One can use this function to return the lowest value (the same value the **MIN **Function would return) or the second lowest value in a data set or the third lowest value in a data set and so on.

__Syntax__:

`=SMALL(array,k)`

Argument | Required/Optional | Explanation |
---|---|---|

array |
Required | The array of data to evaluate |

k |
Required | The position from the largest value which one wants to return |

I have taken a dataset of examination marks to explain the **SMALL **function. I want to find the **Second lowest** marks.

** Steps**:

- Input the following equation to find the second lowest value using the
**SMALL**function:

`=SMALL(D5:D9,2)`

Here, the **SMALL function **runs through the cells **D5:D9 **and returns the second lowest value as I mentioned the position from the lowest value by **2**.

- Now, hit the
**ENTER**button to have the second lowest value.

## Comparison Among MAX vs MAXA vs LARGE and MIN vs MINA vs SMALL Functions in Excel

### Comparison Among MAX, MAXA, and LARGE Functions

We can calculate the highest number using **MAX**, **MAXA**, or **LARGE **functions. But there is a huge difference in terms of calculating the highest marks. I have shown a comparison in the following section where I have calculated the highest value row-wise. From the comparison, we can come to the points:

- Only the
**MAXA**function considers arguments. It considers**TRUE**as**1**and**FALSE**as**0**. So, it returns the output based on both numbers and arguments. But the**MAX**and**LARGE**functions do not consider arguments. They only take numbers into account. - With the
**LARGE**function, we can calculate the Highest number, the second highest number, and so on. But with**MAX**and**MAXA**, we can only calculate the highest number.

### Comparison Among MIN, MINA, and SMALL Functions

Using **MIN**, **MINA **and **SMALL **functions, we can calculate the smallest number. I have tried to show a comparison in the following section by finding the minimum value row wise. Applying the formula explained in the above section, we have created this comparison table. According to the result, we can come to the conclusion that:

- The
**MIN**and**SMALL**functions only consider numbers. They do not take arguments into account. But the**MINA**function considers both numbers and arguments.

2. We can calculate the lowest number and numbers close to the lowest number using the **SMALL **function. But with **MIN **and **MINA**, we can only calculate the lowest number.

## Conclusion

In this article, I have tried to explain a comparison among **MAX vs MAXA vs LARGE** and **MIN vs MINA vs SMALL** functions in Excel. I hope it has given you a complete idea on the differences among them. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

**Read More…**

**Read More…**