Try =A1/MAX($A$1:$A$7) -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Mon, Oct 2, 2023 at 8:13 AM Uwe Brauer <oub@mat.ucm.es> wrote:
Hi I have the following simple table | Marks | Scaled | |-------+--------| | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | In the column scaled I want each value from column Marks, divided by the maximum of column marks which is 7. So I thought | Marks | Scaled | |-------+----------------| | 1 | =A1/max(A1:A7) | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | That gives the correct entry for B1, however if now, drag with the mouse down that formula I obtain | Marks | Scaled | |-------+----------------| | 7 | =A1/max(A1:A7) | | 2 | =B1/max(A2:A7) | | 3 | | | 4 | | | 5 | | | 6 | | | 1 | | Which is not what I want. That is a very elementary question, but google does not help me. regards Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of the Ukraine. I support the EU membership of the Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/ -- 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
-- 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