# Thread: Convert Positive to Negative and Vice Versa (2003)

1. ## Convert Positive to Negative and Vice Versa (2003)

Value in cell A1 is 200 (positive). I want to show this same number in another cell as a negative -200.
I also need it work the other way, if cell A1 number is -200, then I need it show asa positive ???

2. ## Re: Convert Positive to Negative and Vice Versa (2

<P ID="edit" class=small>(Edited by TonyE on 11-Aug-05 17:33. )</P>Multiply the cell by -1

<code>=-1*A1</code>

Or even simpler

<code>=-A1</code>

3. ## Re: Convert Positive to Negative and Vice Versa (2

cell b2 is a positive so cell c3 shows the same number as a negative.
what do I do if cell b2 is a negative and I want cell c3 to show as a positive ?

4. ## Re: Convert Positive to Negative and Vice Versa (2

<code>=-B2</code>

This will convert a negative number to positive & a positive number to negative.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•