=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