[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?
- Subject: Re: [libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?
- From: Steve Edmonds <firstname.lastname@example.org>
- Date: Thu, 3 Oct 2019 12:35:59 +1300
- To: email@example.com
=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:
> Another newbie question: I need to show percentages in columns.
> This involves using a relative cell as numerator, and an absolute cell as
> 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: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|[libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?||Gilles <email@example.com>|
- Prev by Date: Re: [libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
- Next by Date: [libreoffice-users] Re: [newbie/Calc] How to mix relative/absolute cells in formula?
- Previous by thread: [libreoffice-users] Re: [newbie/Calc] How to mix relative/absolute cells in formula?