Talk:Documentation/Calc Functions/SMALL

SF comments

 * (1) Summary. Gives the impression that a single value is calculated, and this is not necessarily the case (when called as an array function). Clarification needed.
 * (2) Results. Again, gives the impression that a single value is calculated, and this is not necessarily the case (when called as an array function). Clarification needed.
 * (3) Arguments, 1st paragraph. Presumably, it would be worth mentioning that the values in Data are intended to be real numbers. What happens if any entry is not a real number? How are logical values TRUE or FALSE treated?
 * (4) Arguments, 2nd paragraph. This paragraph needs more careful wording. I assume that you can pass a single value, an array of values, a reference to a single cell, or a reference to a range of cells. In all cases these must contain positive integers. What happens if any is not an integer?
 * (5) General. What happens if the Data array contains multiple occurrences of a single (legitimate) value?
 * (6) Related LibreOffice functions. Is there any point referring to ROUNDDOWN?

--Stevefanning (talk) 2020-11-05T23:57:38 (UTC)

ronnie
all points addressed.

--Ronnie rg8888 (talk) 2020-11-29T09:51:43 (UTC)