LARGE Function (Functions in Excel)
Values | Highest Value | 800 | =LARGE(C4:C8,1) | |
120 | 2nd Highest Value | 250 | =LARGE(C4:C8,2) | |
800 | 3rd Highest Value | 120 | =LARGE(C4:C8,3) | |
100 | 4th Highest Value | 120 | =LARGE(C4:C8,4) | |
120 | 5th Highest Value | 100 | =LARGE(C4:C8,5) | |
250 |
What Does It Do ? |
This function examines a list of values and picks the value at a user specified position |
in the list. |
Syntax |
=LARGE(ListOfNumbersToExamine,PositionToPickFrom) |
Formatting |
No special formatting is needed. |
Example |
The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar. |
Sales | Jan | Feb | Mar |
North | £5,000 | £6,000 | £4,500 |
South | £5,800 | £7,000 | £3,000 |
East | £3,500 | £2,000 | £10,000 |
West | £12,000 | £4,000 | £6,000 |
Highest Value | £12,000 | =LARGE(D24:F27,1) | |
2nd Highest Value | £10,000 | =LARGE(D24:F27,2) | |
3rd Highest Value | £7,000 | =LARGE(D24:F27,3) |
Note |
Another way to find the Highest and Lowest values would have been to use |
the =MAX() and =MIN() functions. |
Highest | £12,000 | =MAX(D24:F27) |
Lowest | £2,000 | =MIN(D24:F27) |
0 comments:
Post a Comment