Discussion:
Convert Negative numbers to Positive numbers
(too old to reply)
Abc Unha
2009-10-29 18:30:34 UTC
Permalink
Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.

Thanks
SAS_learner
2009-10-29 18:34:29 UTC
Permalink
check for the logic

if number < 0 then Number = Number*-1

this should make all the -ve numbers +ve
Post by Abc Unha
Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.
Thanks
p***@gmail.com
2014-11-01 18:16:34 UTC
Permalink
Post by SAS_learner
check for the logic
if number < 0 then Number = Number*-1
this should make all the -ve numbers +ve
Post by Abc Unha
Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.
Thanks
it works,thanks
Barry Schwarz
2014-11-01 22:36:29 UTC
Permalink
Post by p***@gmail.com
Post by SAS_learner
check for the logic
if number < 0 then Number = Number*-1
this should make all the -ve numbers +ve
Post by Abc Unha
Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.
Thanks
it works,thanks
Why bother multiplying when
Number = -Number
accomplishes the same thing. You can also avoid the comparison
completely with
Number = ABS(Number)
--
Remove del for email
o***@gmail.com
2016-03-15 17:19:15 UTC
Permalink
THIS IS THE EASY WAY I USED

Use the find and replace button
Replace "-" with "".
Done all negative numbers are gone
:)
c***@gmail.com
2016-08-06 19:31:31 UTC
Permalink
Post by o***@gmail.com
THIS IS THE EASY WAY I USED
Use the find and replace button
Replace "-" with "".
Done all negative numbers are gone
:)
Yeah... and all other hyphens are gone too!
m***@gmail.com
2017-12-11 02:43:36 UTC
Permalink
Post by c***@gmail.com
Post by o***@gmail.com
THIS IS THE EASY WAY I USED
Use the find and replace button
Replace "-" with "".
Done all negative numbers are gone
:)
Yeah... and all other hyphens are gone too!
Just make sure you choose the range that includes the negative numbers you want to convert! :D
m***@gmail.com
2018-01-08 21:19:11 UTC
Permalink
Post by o***@gmail.com
THIS IS THE EASY WAY I USED
Use the find and replace button
Replace "-" with "".
Done all negative numbers are gone
:)
GENIUS!!!! Thank you.

j***@jasonforbes.net
2018-01-02 23:20:02 UTC
Permalink
=ABS(A1:A11) will return only a positive or an inverse of the negative.
=ABS(sum(A1:A11)+(A15)) will return a calculated sum as a positive or the inverse of its negative.
=IF(A1<0,0,A1) will return only values greater then 0 or 0 if it is below
=IF((A1:A11)>0,abs(A1:A11),sum(A1:A11)) same as formular 2 but with more flexability in its possible outcomes.

all will return real numbers as you wanted also know as Absolute numbers.
Gerhard Hellriegel
2009-10-29 18:49:39 UTC
Permalink
the ABS-function might do that also.
Gerhard
Post by SAS_learner
check for the logic
if number < 0 then Number = Number*-1
this should make all the -ve numbers +ve
Post by Abc Unha
Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.
Thanks
p***@gmail.com
2014-05-17 00:19:15 UTC
Permalink
hey I have a good question: HOW DO YOU REALLY CONVERT NEGATIVE NUMBERS TO POSITIVE? this is all BS to me. anyone actually know so a human who speaks English can understand ? thx!
p***@gmail.com
2014-05-17 00:20:25 UTC
Permalink
hey I have a good question: HOW DO YOU REALLY CONVERT NEGATIVE NUMBERS TO POSITIVE? this is all BS to me.

it there anyone who actually knows and can explain it so a human who speaks English can understand ? thx!
p***@gmail.com
2014-05-17 00:21:00 UTC
Permalink
hey I have a good question: HOW DO YOU REALLY CONVERT NEGATIVE NUMBERS TO POSITIVE? this is all BS to me.

is there anyone who actually knows and can explain it so a human who speaks English can understand ? thx!
Jason Burke
2014-05-17 21:27:36 UTC
Permalink
Post by p***@gmail.com
hey I have a good question: HOW DO YOU REALLY CONVERT NEGATIVE NUMBERS TO POSITIVE? this is all BS to me.
is there anyone who actually knows and can explain it so a human who speaks English can understand ? thx!
Crawl back into your mama's basement, loser.
Norm Weston
2009-10-29 18:33:18 UTC
Permalink
The function you want is abs()

data test;
val1 = -23;
val2 = abs(val1);
run;
t***@gmail.com
2016-02-25 17:28:56 UTC
Permalink
Can anyone provide more of a beginner level instruction on how to implement these formulas. I'm not sure where or how to apply these or even what they are called. Are the called logics? I can do simple math formulas inside of cells that depend on other cells, but I'm not sure how you apply any of the formulas listed above. A screen grab video on youtube would be great. I'm usually good at searching for them but can not find such a video online yet. This thread however is popping up under many searches on the topic, so it would be really helpful to have this thread solve the problem in a way that less advanced users can understand.
c***@origamirs.com
2016-09-28 00:28:57 UTC
Permalink
I'm a little late to the conversation, but maybe this will help someone else.

If a spreatsheet equation =SUM(A1-B1) returns a negative number, and you want it to be a positive number, change the equation to read =ABS(A1-B1)

Also, ABS stands for absolute value, https://en.wikipedia.org/wiki/Absolute_value
c***@origamirs.com
2016-09-28 00:30:14 UTC
Permalink
I'm a little late to the conversation, but maybe this will help someone else.

If the Google Sheets equation =SUM(A1-B1) returns a negative number, and you want it to be a positive number, change the equation to read =ABS(A1-B1)

ABS stands for absolute value, https://en.wikipedia.org/wiki/Absolute_value
Nathaniel Wooding
2009-10-29 18:33:32 UTC
Permalink
Yes


X = abs( x );

Abs is the absolute value function.

Nat Wooding

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-***@LISTSERV.UGA.EDU] On Behalf Of Abc Unha
Sent: Thursday, October 29, 2009 2:31 PM
To: SAS-***@LISTSERV.UGA.EDU
Subject: Convert Negative numbers to Positive numbers

Is there any function to convert negative to positive numbers?
Or Is there anything to make all numbers positive for that variable,
Regardless number is positive or negative.

Thanks
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.
Loading...