LARGE Excel Formula

Author Zaheer    Category Formulas     Tags ,

Various instructive ways of using Microsoft Excel are included in Microsoft Excel Tutorials, which are designed for beginners. These Excel guides and tutorials completely include sequential steps showing you on how to make use of the Microsoft Excel in producing a basic level worksheet. There are different things that you should understand and be familiar with.

Excel Math

Excel Math teaches you how to subtract, add, divide or multiply numbers in Excel. In addition, it also helps you on how to do it by showing the methods and ways to perform it.

Data Entering in Microsoft Excel

This application covers the basic instructions on how to enter data in the spreadsheet. Basically, you can utilize this function to various items in planning on how to do rightly the spreadsheet before entering the given data, the kinds of data which you are ought to enter, widening of columns, and learning how to edit cells in changing the data.

Spreadsheet Formatting in Microsoft Excel

Formatting is said to be part of worksheet completion. It covers various features in formatting such as:

  • Adding percent and currency symbols
  • Shading alternate data rows
  • Changing the alignment of data
  • Widening columns

Guidelines in Formatting and Creating Excel Charts

A chart or graph is known to be the visual representation of spreadsheet data. It often helps you to easily understand the given data in a worksheet since the user can pick out easily the trends and patterns, which is illustrated in the chart. In Microsoft Excel, the types of graphs or charts that are basically used are bar graph, pie chart, column chart, line graph and even using the Sparklines, which are available in Microsoft Excel 2010.

Working with Functions, Formulas and Data

The function and formula are the two main important features in Microsoft Excel that are often used. There are hundreds of functions and formulas that are used to create a spreadsheet in Microsoft Excel. It is imperative that beginners should learn how to use the spreadsheet or worksheet of Microsoft Excel.

One of the efficient functions of Excel is the LARGE Function. The LARGE function returns the largest value of k-th within the set of data. The user can use this function in selecting the value, which is based on the given relative standing. For instance, the user can fully use this function to return the runner-up, third-place or even the highest score. The syntax of the LARGE function is ‘LARGE(array,k)’. In this formula, the array argument is considered as the range or array of data that the user sought to determine the largest value for k-th. K is considered the position within the cell range or array of data, which is needed to be returned.

REMARKS

  • If the range or array of cell is empty, the LARGE function of Excel returns the #NUM! error value.
  • If K value is greater than the amount of data points or if K is equal to zero, the LARGE function returns the #NUM! error value.

NOTE

If n is considered the number of the given data points, the LARGE function in Microsoft Excel or the ‘LARGE(array,1)’ definitely returns the largest value thus ‘LARGE(array,n)’ returns its smallest value.

Post comment