Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

is it as simple as newx = -1* oldx, or newx = 0-oldx?
or have I misunderstood?

"Soth" wrote in message
...

Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

=-A1
will return the value of A1 with its sign changed (Grade 9 algebra!)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Soth" wrote in message
...

Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

Yes it's that simple.
--
Brevity is the soul of wit.


"David Cox" wrote:

is it as simple as newx = -1* oldx, or newx = 0-oldx?
or have I misunderstood?

"Soth" wrote in message
...

Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

Dave,
Great ! ABS(-10) is what i'm looking for.

But how I do change positive 10 to Negative 10?

I have a list such as below, like to change to operation sign:

-10
10
-20
30
-50

Thanks
Soth




"Dave F" wrote:

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

Hi Soth

multiply the values with -1 (minus one)

say for 10 in A1 multiply it as =A1*(-1)
for -10 in A2 multiply as =A2*(-1)

Hope this works for you.

Thanks,

Shail


Soth wrote:
Dave,
Great ! ABS(-10) is what i'm looking for.

But how I do change positive 10 to Negative 10?

I have a list such as below, like to change to operation sign:

-10
10
-20
30
-50

Thanks
Soth




"Dave F" wrote:

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

You're the best ! Thank you Shail.

Just what i'm lookin for.

"shail" wrote:

Hi Soth

multiply the values with -1 (minus one)

say for 10 in A1 multiply it as =A1*(-1)
for -10 in A2 multiply as =A2*(-1)

Hope this works for you.

Thanks,

Shail


Soth wrote:
Dave,
Great ! ABS(-10) is what i'm looking for.

But how I do change positive 10 to Negative 10?

I have a list such as below, like to change to operation sign:

-10
10
-20
30
-50

Thanks
Soth




"Dave F" wrote:

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

Enter -1 in an empty cell.

Copy that cell and select your range of data.

Editpaste specialmultiply to the selected cells.


Gord Dibben MS Excel MVP


On Tue, 5 Sep 2006 11:39:02 -0700, Soth wrote:

Dave,
Great ! ABS(-10) is what i'm looking for.

But how I do change positive 10 to Negative 10?

I have a list such as below, like to change to operation sign:

-10
10
-20
30
-50

Thanks
Soth




"Dave F" wrote:

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea

Hi Soth
Thanks for the feedback.

Shail


Soth wrote:
You're the best ! Thank you Shail.

Just what i'm lookin for.

"shail" wrote:

Hi Soth

multiply the values with -1 (minus one)

say for 10 in A1 multiply it as =A1*(-1)
for -10 in A2 multiply as =A2*(-1)

Hope this works for you.

Thanks,

Shail


Soth wrote:
Dave,
Great ! ABS(-10) is what i'm looking for.

But how I do change positive 10 to Negative 10?

I have a list such as below, like to change to operation sign:

-10
10
-20
30
-50

Thanks
Soth




"Dave F" wrote:

For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10.

I'm not aware of a function which returns the negative equivalent of a
positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10.

Dave
--
Brevity is the soul of wit.


"Soth" wrote:


Hi

How do I creat a formula by switching the operation sign, for example:

From Negative Ten (-10) to positive of 10

Vice versa

From Positive of 10 to Negative (-10)

Thank you
Sothea