Convert Negative numbers to Positive numbers

[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

[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]

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]

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)

[o***@gmail.com]

THIS IS THE EASY WAY I USED

Use the find and replace button
Replace "-" with "".
Done all negative numbers are gone
:)

[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!

[m***@gmail.com]

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]

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]

=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]

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]

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]

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]

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]

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]

The function you want is abs()

data test;
val1 = -23;
val2 = abs(val1);
run;

[t***@gmail.com]

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]

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

[g***@gmail.com]

Thank you! This finally made it clear and usable in a formula that worked for a googlesheet/excel novice!!

[c***@origamirs.com]

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]

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.