Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Hi,
I'm using Libreoffice calc. Can someone help me with calculating the absolute value of an entire column. Is there a command for that. I don't really want to do it for each element as the # of elements are huge.
Thanks!
It's fairly simple to do. Assume a column of 100 elements. In cell A101, use the Sum() function to sum the first 100 elements. In cell A102, use the formula =ABS(A101) to return the absolute value of the sum in cell A101.
Hi,
Thanks for your reply.
However I do not want the absolute value of the sum of the elements of a column.
I want the absolute value of each and every element of the column. And paste it into the adjacent column.
Thanks!
Best,
Adwait
Quote:
Originally Posted by bigrigdriver
It's fairly simple to do. Assume a column of 100 elements. In cell A101, use the Sum() function to sum the first 100 elements. In cell A102, use the formula =ABS(A101) to return the absolute value of the sum in cell A101.
Assume the 100 elements I mentioned are in column A. Then, in column B, proceed as follows:
In B1, add the formula =ABS(A1)
In B2, add the formula =ABS(A2)
In B3, add the formula =ABS(A3)
Then select the three cells B1:B3
Grab the bottom right corner and drag it to the bottom of the column at B100. The formulas should progress in numerical order to =ABS(A100).
I know it isn't what you want, but it's all I know.
Last edited by bigrigdriver; 06-09-2012 at 04:14 PM.
For the actual benefit of future googlers, the above reply is not what OP was asking.
They were asking for a way to take the absolute value of a range of numbers.
The ABS function is single valued, so you have to make a column.
A fairly fast way to do this is in the B1 cell put ABS(A1) at the beginning of the column,
then copy paste or copy-"drag the corner"-paste into the range you want it.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
