On Fri, 2 Oct 2020 06:41:27 -0700 (MST) Chimel <[email protected]> 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: [email protected] 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
