Difference between revisions of "Manuals/calci/SMALL"

Revision as of 00:06, 26 October 2015

SMALL(ar,n)

This function gives the $n^{th}$ smallest value in given array of numbers.
In $SMALL(ar,n)$ , $ar$ is the array or range of cells containing the data to be used in the function and $n$ is the position of the smallest number.
This function can be used to find data based on relative size.
Here $SMALL(ar,1)$ = Smallest value in the given set.
Suppose there is $m$ number of data points in a given array, then $SMALL(ar,m)$ = Largest value in the given set.
This function will give the result as error when

 1. The  $ar$  values are empty.
 2.  $n\leq 0$  or  $n$  is greater than the number of data points.

Spreadsheet
	A	B	C	D	E	F	G
1	-6	-12	-20	-10	-15	0	-25
2	1.2	1.5	1.25	1.62	1.521	1.7	1.76

@@ Line 14: / Line 14: @@
 ==Examples==
-#Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39}
+*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],2) = -1
-*=SMALL(F1:F14,2) = -1
+*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],7) = 9
-*=SMALL(F1:F14,7) = 9
+*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],1) = -5
-*=SMALL(F1:F14,1) = -5
+*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],14) = 70
-*=SMALL(F1:F14,14) = 70
+{| class="wikitable"
-#Array = {-6,-12,-20,-10,-15,0,-25}
+|+Spreadsheet
-*=SMALL(E1:E7,4) = -12
+|-
-*=SMALL(E1:E7,6) = -6
+! !! A !! B !! C !! D!! E!! F !! G
-#Array = {1.2,1.5,1.25,1.62,1.521,1.7,1.76}
+|-
-*=SMALL(B1:B7,6) = 1.7
+! 1
-*=SMALL(B1:B7,8) = NAN
+| -6 || -12 || -20 || -10 || -15 || 0 || -25
+|-
+! 2
+| 1.2 || 1.5 || 1.25 || 1.62 || 1.521 || 1.7 || 1.76
+|}
+*=SMALL(A1:G1,4) = -12
+*=SMALL(A1:G1,6) = -6
+*=SMALL(A2:G2,6) = 1.7
+*=SMALL(A2:G2,8) = NAN
 ==Related Videos==