SMALL
What Does It Do ?
This function examines a list of values and picks the value at a user specified position
in the list.
This function examines a list of values and picks the value at a user specified position
in the list.
Syntax
=SMALL(ListOfNumbersToExamine,PositionToPickFrom)
Formatting
No special formatting is needed.
=SMALL(ListOfNumbersToExamine,PositionToPickFrom)
Formatting
No special formatting is needed.
Example
The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar.
The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar.
Note
Another way to find the Highest and Lowest values would have been to use
the =MAX() and =MIN() functions.
Another way to find the Highest and Lowest values would have been to use
the =MAX() and =MIN() functions.
Hello, my name is Amit Gupta. I'm a 28 year old passionate about computer Youtube & Blogger.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें