Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>

    Added:
    Or even simpler

    <code>=-A1</code>

  3. #3
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    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
  •