Excel is a spreadsheet program that is developed for Windows, Mac, Android, 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 Enter 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 Enter 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.
Verdict
To sum up, I hope this article helped you to learn the usage of the Excel LARGE Function with its syntax, explanation, and examples. Kindly, give your feedback in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
The following video will show you how to apply the LARGE function in your Excel worksheet.
Read Ahead:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.
