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)