[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
BertrandSz
Newbie

Joined: 24 May 2012
Posts: 1

Posted: Thu May 24, 2012 4:45 pm    Post subject: copying positive and negative numbers one column to another

Hello,

My Dad the retired engineer is asking me for some tech support in OO Calc, help!

He has column E, F, G

In E he has a list of positive and negative numbers. Such as:

56
-9
90
-3.7

He is asking how you do a formula so that the positive numbers in column E are copied in the same row in column F and the negative numbers in column E are copied (times -1) in column G so that you get something like:

 Code: 56      56    -9                9 90      90 -3.7             3.7

We looked at the help file, googled it, tried formulas, looked at how Excel does it and tried imitating. What is the trick, how do you do that?

Be kind, help out an unworthy son.

Cheers,
Bert
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

Posted: Thu May 24, 2012 5:07 pm    Post subject:

If the column E values start in E2 then try...
 Code: =IF(E2>=0;E2;"")
in F2 and
 Code: =IF(E2<0;ABS(E2);"")
in G2 then select F2:G2 and double-click the fill handle.

Ken Johnson
_________________