Results 1 to 10 of 10

Transpose a Negative Number to Positive and Vice Versa

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-15-2008
    Posts
    140

    Thumbs up Transpose a Negative Number to Positive and Vice Versa

    I am wanting to be able to enter in a number in one cell and then have it's negative equivalent appear in another cell or enter a negative number in a cell and have its positive equivalent appear in another cell. Example: I enter the negative number (11.5) in F4 and I want the positive number 11.5 to then also appear in F10.

    Or I enter the positive number 2.5 in F5 and I want the negative number (2.5) to appear in F12.

    I can attach a sample worksheet if that would help.
    Last edited by tomvh444; 09-08-2011 at 10:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1