[libreoffice-users] Re: [newbie/Calc] How to mix relative/absolute cells in formula?
Brian Barker wrote > 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. Thank you! -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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
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+unsubscr...@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
Re: [libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?
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: users+unsubscr...@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
Re: [libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
On 03/10/2019 11:55, Gilles wrote: > Johnny Rosenberg wrote >> If your cell was formatted as text, then whatever you type into that cell >> will be displayed as pure text. The funny thing is that changing the >> format doesn't help. You must first empty the cell, then format it as a >> number, then type your formula again. You can also first format the cell >> to a number format, then empty it and >> finally enter your formula again. > Makes sense. Thank you (and to someone off-band)! > You do not even need to empty the cell, after making sure the cell is formatted number just edit the formula [like remove the last ) and retype it] and then press enter. =SUM(B4:B8) > =SUM(B4:B8 > =SUM(B4:B8) and enter. Just out of interest, there is no difference in the number of actions required,. -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?
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+unsubscr...@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
[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
Johnny Rosenberg wrote > If your cell was formatted as text, then whatever you type into that cell > will be displayed as pure text. The funny thing is that changing the > format doesn't help. You must first empty the cell, then format it as a > number, then type your formula again. You can also first format the cell > to a number format, then empty it and > finally enter your formula again. Makes sense. Thank you (and to someone off-band)! -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] [newbie/Calc] Why does SUM() not compute?
Den ons 2 okt. 2019 kl 19:58 skrev Gilles : > Hello, > > I made sure the column is set to Number. > > For some reason, SUM() doesn't work. It only displays the formula: > > https://postimg.cc/k29XkyJs > > Any idea why? > If your cell was formatted as text, then whatever you type into that cell will be displayed as pure text. The funny thing is that changing the format doesn't help. You must first empty the cell, then format it as a number, then type your formula again. You can also first format the cell to a number format, then empty it and finally enter your formula again. Kind regards Johnny Rosenberg > > Thank you. > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > > -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
Thanks. No change. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] [newbie/Calc] Why does SUM() not compute?
On Wed, 2 Oct 2019 10:55:58 -0700 (MST), Gilles wrote: > Hello, > > I made sure the column is set to Number. > > For some reason, SUM() doesn't work. It only displays the formula: > > https://postimg.cc/k29XkyJs > > Any idea why? Try menu View -> Show formula -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] [newbie/Calc] Why does SUM() not compute?
Hello, I made sure the column is set to Number. For some reason, SUM() doesn't work. It only displays the formula: https://postimg.cc/k29XkyJs Any idea why? Thank you. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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