Difference between revisions of "Manuals/calci/SMALL"
Jump to navigation
Jump to search
Line 25: | Line 25: | ||
*=SMALL(B1:B7,6) = 1.7 | *=SMALL(B1:B7,6) = 1.7 | ||
*=SMALL(B1:B7,8) = NAN | *=SMALL(B1:B7,8) = NAN | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|JRrXuCvtmdc|280|center|SMALL}} | ||
==See Also== | ==See Also== |
Revision as of 14:55, 25 June 2015
SMALL(ar,n)
- is the array of numbers.
- is the position of a smallest number.
Description
- This function gives the smallest value in given array of numbers.
- In , is the array or range of cells containing the data to be used in the function and is the position of the smallest number.
- This function can be used to find data based on relative size.
- Here = Smallest value in the given set.
- Suppose there is number of data points in a given array, then = Largest value in the given set.
- This function will give the result as error when
1. The values are empty. 2. or is greater than the number of data points.
Examples
- Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39}
- =SMALL(F1:F14,2) = -1
- =SMALL(F1:F14,7) = 9
- =SMALL(F1:F14,1) = -5
- =SMALL(F1:F14,14) = 70
- Array = {-6,-12,-20,-10,-15,0,-25}
- =SMALL(E1:E7,4) = -12
- =SMALL(E1:E7,6) = -6
- Array = {1.2,1.5,1.25,1.62,1.521,1.7,1.76}
- =SMALL(B1:B7,6) = 1.7
- =SMALL(B1:B7,8) = NAN