Welcome to the most active Linux Forum on the web.
 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.

 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 stable Posts: 5,908 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 stable Posts: 5,908 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. 1 members found this post helpful.
 07-31-2021, 03:30 PM #6 kylearean LQ Newbie   Registered: Jul 2021 Posts: 1 Rep: 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. Calc is not smart enough to create a column.

 Tags libreoffice

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post knobby67 Linux - Software 5 01-11-2015 04:45 AM ubume2 Ubuntu 0 05-18-2012 08:20 AM Myrlin Linux - Desktop 6 11-04-2011 06:16 AM resetreset Linux - Software 2 07-28-2011 09:52 AM Marel Linux - Desktop 3 05-05-2008 03:23 PM

LinuxQuestions.org

All times are GMT -5. The time now is 05:21 AM.

 Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -