Talk:Documentation/Calc Functions/SMALL

    From The Document Foundation Wiki

    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)