Re: [libreoffice-users] Static vs. dynamic maximum

On Fri, 2 Oct 2020 06:41:27 -0700 (MST)
Chimel <chimel31@live.fr> wrote:

> Hi,
>
> I must be of a conservative mind today, because after the message
> about static NOW(), I am also stuck with extracting the maximum value
> of one given cell.

What do you mean by 'the maximum value' of a cell?

It sounds like you think cells have a history of their contents?
That's not the case. A cell has a value. If you then enter a different
value in the cell, it has the new value. It does not 'remember' the old
value. (Notwithstanding the ability of the UI to 'undo' editing -
that's something completely different).

So the entire notion of the 'maximum' value of a cell is meaningless.

> For instance, A1 contains variable numbers, and I want to store the
> maximal value of this cell in B1.
> The trouble is that MAX() compares 2 different cells, whereas I want
> the maximal value of one cell.
> A recursive formula such as =MAX(A1;B1) would probably not work, and
> returns an error 523 indeed.
>
> Is there a way to store the maximal value of a cell using a formula,
> preferably?
>
> Thanks,
> Chimel.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy