# How to Use Excel LARGE Function?

Excel is a spreadsheet program that is developed for WindowsMacAndroid, and iOS. It helps to perform calculations on your PC. The purpose of this software is to do complicated calculations which are difficult to do manually. If you want to find the largest number from the range on your Excel spreadsheet, we suggest you use the LARGE function.

This article describes the usage of the Excel LARGE Function 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

## Explanation of LARGE Function

• The LARGE function in Excel is one of the built-in functions.
• This function returns the Nth 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

• Here, you will see the syntax of the LARGE function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=LARGE(array, n)

Parameters Description:

• Array – The array or range of inputs from which you want to find the Nth Largest value.
• n – The position (Nth Largest) in the array or range that you want to be returned.

Note:
1) If the array is empty and then returns #NUM! Error value.
2) If the argument n is less than 0 or greater than the number of input elements, then it returns the #NUM! Error value.

## Examples

Let’s see some examples to make it clear how to apply the LARGE function in Excel.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have shown you a range of student’s marks in the following image. From this, we will find the first and second-largest values using the LARGE function.
• Now, we need to enter the above-mentioned formula to get the result.
• After entering the formula, you need to click the button to get the output, as shown below.

## Input that Causes Error

• As we said earlier, If the argument n is less than 0 or greater than the number of input elements, then it returns the #NUM! Error value.