|
|
|
|
|
|
|
Lesson 20: MIN, MAX, SMALL and LARGE Functions in Excel
The MIN functions returns the smallest
value in a data set. For example: The SMALL functions returns the first or second or third... smallest
value in a data set. For example: So =SMALL(D2:D7,1) will return the same result as =MIN(D2:D7) . Clean your tool box and forget about MIN now that you know that SMALL does the same as MIN and more. The MAX functions returns the largest
value in a data set. For example: The LARGE functions returns the first or second or third... smallest
value in a data set. For example: So =LARGE(D2:D7,1) will return the same result as =MAX(D2:D7) . Clean your tool box and forget about MAX now that you know that LARGE does the same as MAX and more. SUMPRODUCT Function in Excel |
|
|
|