[libreoffice-users] Static vs. dynamic maximum

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.
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.



--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
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