Register a domain and help support LQ
 Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 LinuxQuestions.org Absolute value of a column in Libreoffice calc
 Linux - Software This 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

 06-08-2012, 09:29 PM #1 Adwat LQ Newbie   Registered: May 2012 Posts: 14 Rep: Absolute value of a column in Libreoffice calc 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!
 06-09-2012, 03:58 PM #2 bigrigdriver LQ Addict Contributing Member   Registered: Jul 2002 Location: East Centra Illinois, USA Distribution: Debian Squeeze Posts: 5,818 Rep: 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.
06-09-2012, 04:00 PM   #3
LQ Newbie

Registered: May 2012
Posts: 14

Original Poster
Rep:
Hi,
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,

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.

 06-09-2012, 04:13 PM #4 bigrigdriver LQ Addict Contributing Member   Registered: Jul 2002 Location: East Centra Illinois, USA Distribution: Debian Squeeze Posts: 5,818 Rep: 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.
 03-10-2015, 05:35 AM #5 duncangibb LQ Newbie   Registered: Mar 2015 Posts: 1 Rep: SUMPRODUCT(ABS( range )) For the benefit of future Googlers, you can use SUMPRODUCT(ABS(A1:A100)) to do this.

 Tags libreoffice