How to Use Excel LARGE Function in Office 365? – {with Examples}
Tags: excelfunctions, excellargefunctionin
Published: 2020-09-03 10:48:55

---
title: How to Use Excel LARGE Function in Office 365? – {with Examples}
published: true
date: 2020-09-03 07:19:50 UTC
tags: ExcelFunctions,ExcelLARGEFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/
---

## Excel LARGE Function:

![LARGE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/LARGE-Function.png)<figcaption id="caption-attachment-13237">LARGE Function</figcaption>

This article describes the usage of **Excel LARGE Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! 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)
## **LARGE Function – Explanation:**

- This function returns the **N<sup>th</sup>**  **Largest value from the given range of data.**
- For example, you can find the **highest value** from the range or **second-largest value** , or **third-largest value** using this **LARGE Function**.

## **Syntax:**

**=LARGE(array, n)**

### Parameters Description:

**Array ** – The array or range of inputs from which you want to find the **N<sup>th</sup>**  **Largest value.**

**n** – The position ( **N<sup>th</sup>**  **Largest ** ) in the array or range that you want to be returned.

### Note:

- If the array is empty and then returns [**#NUM!**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) Error value.
- If the argument n is less than 0 or greater than the number of input elements, then it returns the[**#NUM!**  **Error value**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

## **Examples:**

Let’s see some examples below.

### Example 1:

- Refer to the below example image.
- You can see the input array is listed in **Column B** and the **N<sup>th</sup>**  **Largest values ** are given in **Column E**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-12.png)<figcaption id="caption-attachment-13234">Example 1</figcaption>

### Example 2:

- If the array is empty and then returns [**#NUM!** Error value](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the argument n is less than 0 or greater than the number of input elements, then it returns the[**#NUM!** Error value](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-10.png)<figcaption id="caption-attachment-13235">Example 2</figcaption>

## **Verdict:**

To sum up, I hope this article helped you to learn the usage of **Excel LARGE Function in Office 365** with its syntax, explanation, and examples. Kindly, give your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [How to Use Excel COS Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-cos-function-in-office-365-with-examples/)
- [How to Use Excel LCM Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-lcm-function-in-office-365-with-examples/)