what means "k" in Excel formula

[Llupo01]

Hello all,

i have really quick question. Does anyone pls know, what means "k" in formulas in Excel? And I dont mean function of it, I know what it is and what it does...I would like to know, what word is hidden under the "k" shortcut... I was trying to search everywhere and did not find it.

This is not important, I am just wondering, because few people already asked me and I couldnt answer

Thank you very much in advance.

Regards,
Tom

 

[mole999]

do you have an example of a formula with it in

 

[Llupo01]

Sure, for example Small, Large..."k" means required position you want to display when using fuction. For example :

=SMALL($A$1:$A$10,1)

means display first smallest value from range A1:A10. And in this case, "k" is 1. If I would like to display second smallest, it would be 2 etc....What I am curious at is, what means that "k"..shortcut of what word it is

 

[Aladin Akyurek]

k is used to indicate a whole number like N, n, i, j in maths or statistics. Thus, just a convention to use such as a symbol for a whole number.

k in small (or in large for that matter) will run from 1 to the size of the range of interest. That is, SMALL(range,k), where k = 1,...,size(range).

 

[Llupo01]

understand. Thank you and have a good day.

 

[Aladin Akyurek]

understand. Thank you and have a good day.

You are welcome.