The SMALL function is useful when you want to
extract the kth smallest value from a dataset.
advanced excel small formula excel small function small function excel small excel small function in excel excel small small formula excel excel small function for text small formula in excel excel small if small if excel small () excel function.
Description of Small Formula:
The Excel SMALL function returns numeric values based
on their position in a list, ranked by value. The Microsoft
Excel SMALL function returns the nth smallest value from
a set of values. The SMALL function is a built-in function
in Excel that is classified as a statistical function. It can
be used as a worksheet function in Excel. As a worksheet
function, the SMALL function can be entered as part of a
formula in a cell of a worksheet. Returns the kth smallest
value in a dataset. Use this function to return values at
a specific relative position in the dataset.
Syntax of Small Formula
=SMALL(ARRAY, K)
Examples of Small Formula
the first, second or third fastest time in a race.
Jockey No
|
Time taken
|
Result of race
|
Time taken
|
1
|
5:45
|
1
|
4:05
|
2
|
6:01
|
2
|
4:10
|
3
|
4:10
|
3
|
4:19
|
4
|
5:13
|
||
5
|
4:19
|
||
6
|
6:22
|
||
7
|
4:05
|
||
8
|
6:50
|
||
9
|
7:54
|
||
10
|
6:57
|
Errors in Small formula
If array is empty, SMALL returns the #NUM! error value.
If k ≤ 0 or if k exceeds the number of data points,
SMALL returns the #NUM! error value.
If n is the number of data points in array,
SMALL(array,1) equals the smallest value,
and SMALL(array,n) equals the largest value.
 |
| small formula |
0 comments: