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.
And thanks in advance!
Cheers,
Bert |
|
