Talk:Documentation/Calc Functions/AVERAGEA

    From The Document Foundation Wiki

    SF Comments

    (1) Returns. No statement given.
    (2) Arguments. Please re-write to describe the arguments shown in the Syntax section.
    (3) Additional details. It seems illogical to try to further describe arguments in this section. Details like these should surely be in the Arguments section? With respect to the current contents of the Additional details section, I would prefer to discuss limitations of the AVERAGE function on that function’s page, not on this page. Note that while you cannot pass a text string as an argument to AVERAGE, you can pass a reference to a cell that contains a text string.
    (4) Additional details. Is it worth saying that the result is the sum of the numbers divided by the count of the numbers?
    (5) As a further thought, how do AVERAGE and AVERAGEA react to passing logical values as arguments?

    --Stevefanning (talk) 2020-10-05T15:07:03 (UTC)

    RG Reply

    • 1-4 points addressed
    • For the 5th point, both AVERAGE and AVERAGEA on passing one argument as > sign gave a popup indicating correction of the formula with that argument deleted. But I believe all functions that accept number will have same reactions to text being passed unless their is a special provision for it and same shall be the case with logical operator but at least logical operator seems redundant here.