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 <[email protected]> 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: [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 > -- 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
