[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?


=A3/$B$2 and copy down. Denominator in B2

Pressing F4 while clicked on B2 (in the formula) will cycle through the
$ options. I think of the $ as "freeze" or "lock".
Freeze column at B, freeze row at 2

On 03/10/2019 12:00, Gilles wrote:
> Hello,
>
> Another newbie question: I need to show percentages in columns.
>
> This involves using a relative cell as numerator, and an absolute cell as
> denominator.
>
> https://postimg.cc/G9tccRmV
>
> I tried adding $…
> 1. in the first cell: NOK.
> 2. in the second cell: NOK.
>
> How can I apply the formula to all cells downward?
>
> Thank you.
>
>
>
> --
> 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

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.