Jump to content

Talk:Documentation/Calc Functions/MINA

From The Document Foundation Wiki

SF comments

(1) Summary. Suggest replacing with “Identifies the minimum value in the list of numbers passed as arguments. Cells containing text are given the value 0 and empty cells are ignored.”.
(2) Syntax. Change “MINa” to “MINA”.
(3) Returns. Suggest change “Number Number 1, Number 2, … , Number 255” to simply read “numbers”. Also suggest deleting “including text values which are counted as 0” and adding the sentence “Empty cells are ignored and cells containing text are given the value 0.”.
(4) Arguments, 1st paragraph. Suggest changing 2nd sentence to “Empty cells are ignored and cells containing text are given the value 0.”.
(5) Arguments, 1st and 2nd bullets. Not sure why we are discussing MAXA() here.
(6) Additional details. Would it be worth saying that the logical value TRUE counts as 1, while FALSE counts as 0?
(7) Examples, 3rd example. The numbers listed in the description do not match those in the formula. I think the formula would probably return -4.2. Please review and update.

--Stevefanning (talk) 2020-10-27T16:39:08 (UTC)

Ronnie

all points addressed.

--Ronnie rg8888 (talk) 2020-11-27T12:27:50 (UTC)