At 16:00 02/10/2019 -0700, Gilles Noname wrote:
Another newbie question: I need to show percentages in columns. This involves using a relative cell as numerator, and an absolute cell as denominator. [...] 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?
You have the denominator in your formula as $E2, which doesn't quite do what you want. That $ holds the column indicator, E, fixed, so that it would not be automatically changed to another column (F2, G2, ...) if you filled or copied the formula to other *columns*. What you need here is just to keep the row indicator, 2, fixed, so you need E$2 instead. (If you needed to keep both fixed, you would need $E$2.) Use =E3/E$2. I'm assuming that you know how to fill this down the column.
Incidentally, I don't want to be dismissive, but you cannot really expect to learn the basics of spreadsheets by asking questions of hundreds, perhaps a thousand or two, of fellow user around the world. You may want to find a book, get advice from a friend, take a course (at school/college? at work? in a library? or elsewhere?), search the web, or perhaps join a club. But don't let me put you off asking.
I trust this helps. Brian Barker -- 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
