| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there NOT a "make negative" function? and if not WHY??????? | Excel Discussion (Misc queries) | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Hybrid Mode
