Date: prev next · Thread: first prev next last
2023 Archives by date, by thread · List index



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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.