Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mustard
 
Posts: n/a
Default 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   Report Post  
Sloth
 
Posts: n/a
Default

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   Report Post  
David Hepner
 
Posts: n/a
Default

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   Report Post  
mustard
 
Posts: n/a
Default


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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there NOT a "make negative" function? and if not WHY??????? jenniferlawhp Excel Discussion (Misc queries) 8 August 11th 05 01:23 AM
how do I rank negative and positive numbers? Anna Excel Worksheet Functions 1 April 6th 05 12:36 AM
Goal Seek - Why make the PV negative? Mytpoet67 Excel Discussion (Misc queries) 1 January 13th 05 03:51 AM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 10:02 PM
How do I replace a negative number at the end of a formula with a. dealn2 Excel Discussion (Misc queries) 5 December 23rd 04 08:47 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"