About Us

shail

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Creating a check mark box	MarthaSue	Setting up and Configuration of Excel	18	April 28th 05 12:31 AM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM

Menu

About Us