=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: [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
