By Laura

- Excel – MAXA function, returning largest value
- Excel – Examples and guidance for VALUE function- a function for converting string to number
- Excel - How to using the SUM function
- Excel - PRODUCT function for multiplying

In Excel, LARGE function is used quite frequently. This function has a simple syntax, but has a very tremendous application. Let’s follow this article from betdownload.com to understand the syntax as well as usage of LARGE function.

__HOW TO USE LARGE FUNCTION IN EXCEL, ILLUSTRATION__*Syntax:* **LARGE( array,k)***In which:*

- **Array**: The data array that you want to find the largest value number k, in which

- **K**: is the rank of the value that you want to search for in the data array.

Arguments are required in **LARGE **function.

Example: Given a transcript of some students, find out the highest and second highest scores?

Use formula in cell **C7: =LARGE($C$2:$C$6;1)**

**Cell C8: =LARGE($C$2:$C$6;2)****Result:**

The usage of LARGE function to find the largest value number k is simple with several manipulations above. This function is widely used in the work or studying. In addition, you can refer to the usage of other functions in Excel.

- Related Articles:
- Excel – AVERAGEIF function, calculating average with conditions
- Excel – FREQUENCY function, counting frequently-appeared values
- Excel - LEFT function, for cutting left string
- AVERAGEIFS function, calculating average with multiple conditions
- Excel – HLOOKUP function - a search function in Excel
- Excel - How to use the ConcateNate function to connect character strings in Excel

Related software

K-3D is the software which supports users to create models, 3D animations professionally and easily. With this utility, you can freely design unique 3D animations from the simple to the complex for different aims.

- Sendago - Send large files via email
- Free Large Android Icons - Large Android Icons.
- K Media Center - Listen to karaoke music

Excel – Examples and guidance for VALUE function- a function for converting string to number

To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will

Excel – AVEDEV function, calculating absolute deviation average

In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve

AVERAGEIFS function, calculating average with multiple conditions

You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without

Excel – AVERAGEIF function, calculating average with conditions

AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and

Excel - PRODUCT function for multiplying

To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and