Large MIN MAX Sum(large)

MAXIMUM AND MINIMUM LARGE AND SMALL IN EXCEL

Maximum function returns maximum values in a given range while minimum returns minimum value



The syntax for maximum value is =MAX(range)

MAXIMUM

Type “=” followed by max where the value should be placed

minfig1

Then select the range

minfig2

Finally enter

minfig3

You can now auto fill the formula to the other cells

MINIMUM

Minimum works in a similar way and returns the lowest value

Its syntax is =MIN(range)

 

LARGE

Large function return returns the nth large value

Syntax =LARGE(array,k)

Array is the range

K is the is the large number eg the fifth etc



In the example below we get the 3rd largest

Type = the LARGE and select the range

 

minfig5

 

Put a comma then type 3

minfig6

Then enter

Then auto fill the formula in the other cells

minfig7

COMBINING SUM AND LARGE

If you want to add the first largest 3 figures

Syntax =SUM(LARGE(array,{1,2,3}))

Not the use of the curry brackets following by the ones we want to sum( 1st ,2nd, and 3rd)

Click where you want your answer to be and type = followed by SUM then an opening bracket and then type LARGE or select from pop up menu type another opening bracket and select the range

minfig8

Type a comma followed by a curry bracket and then 1, 2, 3

Close the curry bracket

Close the other two brackets

minfig9

Enter then auto fill the formula for the other cells

minfig10

 

NOTE

SMALL FUNCTION works in a similar way but returns from the smallest

You can try summing up the 3 smallest numbers




Leave a Reply

Your email address will not be published. Required fields are marked *