|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 26th, 2005, 07:52 PM
|
|||
|
|||
Formula to make Negative Values Positive & Positive Values Negative?
I would like to know if there is any way to have a formula/function that takes a value from another cell (I know how to do that part) and then makes the number negative if the original is positive - or else makes the number positive if the original is negative. Any ideas? -- mustard ------------------------------------------------------------------------ mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017 View this thread: http://www.excelforum.com/showthread...hreadid=470855 
|
|
#2
September 26th, 2005, 08:16 PM
|
|||
|
|||
|
Just multiply it by -1
example: =-1*A1 "mustard" wrote: I would like to know if there is any way to have a formula/function that takes a value from another cell (I know how to do that part) and then makes the number negative if the original is positive - or else makes the number positive if the original is negative. Any ideas? -- mustard ------------------------------------------------------------------------ mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017 View this thread: http://www.excelforum.com/showthread...hreadid=470855
|
|
#3
September 26th, 2005, 08:18 PM
|
|||
|
|||
|
You can:
- put '-1' in an empty cell and copy this cell - select your data - goto 'Edit - Paste Special' and choose 'Multiply' or create a helper column and use this formula: =-A1 (aussmuing your numnber is in A1) and drag down the formula. "mustard" wrote: I would like to know if there is any way to have a formula/function that takes a value from another cell (I know how to do that part) and then makes the number negative if the original is positive - or else makes the number positive if the original is negative. Any ideas? -- mustard ------------------------------------------------------------------------ mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017 View this thread: http://www.excelforum.com/showthread...hreadid=470855
|
|
#4
September 26th, 2005, 09:16 PM
|
|||
|
|||
|
That worked great. Thank you. -- mustard ------------------------------------------------------------------------ mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017 View this thread: http://www.excelforum.com/showthread...hreadid=470855
|
|
#5
September 26th, 2005, 10:05 PM
|
|||
|
|||
|
mustard
By formula in A1 enter =b1*-1 where b1 is negative or positive. Without a formula enter -1 in any empty cell then copy and select cells to change then Paste SpecialMultiplyOkEsc on all selected cells. Gord Dibben Excel MVP On Mon, 26 Sep 2005 13:52:43 -0500, mustard wrote: I would like to know if there is any way to have a formula/function that takes a value from another cell (I know how to do that part) and then makes the number negative if the original is positive - or else makes the number positive if the original is negative. Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
| sum formula does not tally all values in column | Asleeplessknight | General Discussion | 1 | August 19th, 2004 07:54 PM |
| Can I make a formula that has the result of "0" remain empty? | DangerMouse114 | Worksheet Functions | 2 | May 12th, 2004 06:00 AM |
| negative hour/min values | emily | Worksheet Functions | 4 | November 11th, 2003 03:44 AM |
| Formula Calculating Minus Values | Russ | Worksheet Functions | 2 | October 6th, 2003 03:06 PM |
Linear Mode
