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
|
|||
|
|||
change a positive number to negative
How to change a positive number to negative?
|
#2
|
|||
|
|||
change a positive number to negative
Multiply the number by -1 to reverse its sign:
A1: -10 =A1*-1 returns 10 A1: 10 =A1*-1 returns -10 -- Biff Microsoft Excel MVP "MICHALK" wrote in message ... How to change a positive number to negative? |
#3
|
|||
|
|||
change a positive number to negative
Try the below
--Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? |
#4
|
|||
|
|||
change a positive number to negative
Try this:
=MIN(A1,-A1) This will keep negative numbers and turn positive numbers to negative. Hope this helps. Pete On Nov 12, 5:07*pm, MICHALK wrote: How to change a positive number to negative? |
#5
|
|||
|
|||
change a positive number to negative
=is(a1)0,-a1,a1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "MICHALK" wrote in message ... How to change a positive number to negative? |
#6
|
|||
|
|||
change a positive number to negative
Try these.
1. When entering the number, put a minus sign in front of it. 2. If your positivie number is in cell A1, enter =-a1 in, say cell b1. 3. If you have a group of mixed numbers (positive and negative), use an IF statement in cell b1. E.g. =if(a1=0,a1,-a1) and copy. "MICHALK" wrote: How to change a positive number to negative? |
#7
|
|||
|
|||
change a positive number to negative
Sorry, clicked SEND before I finished!
-- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... =is(a1)0,-a1,a1) -- Kind regards, Niek Otten Microsoft MVP - Excel "MICHALK" wrote in message ... How to change a positive number to negative? |
#8
|
|||
|
|||
change a positive number to negative
"Jacob Skaria" wrote: Try the below --Enter -1 in a cell and copy the cell --Keeping the copy; select the data range to be converted (say A1:A100). --Press F5. From Goto windowSpecial select 'Multiply' and hit OK If this post helps click Yes --------------- Jacob Skaria "MICHALK" wrote: How to change a positive number to negative? Thanks...but I don't have Multiply as an option in that menu. |
#9
|
|||
|
|||
change a positive number to negative
If your postitive number is in A1, =-A1 will give you the negative number.
Otherwise you put -1 in a spare cell, Copy, then select the cell(s) containing your positive number(s), and Edit/ Paste Special/ Multiply (or Divide). The simple thing to remember is that Excel uses a hyphen as a minus sign. -- David Biddulph "MICHALK" wrote in message ... How to change a positive number to negative? |
#10
|
|||
|
|||
change a positive number to negative
"NonTechie" wrote: Try these. 1. When entering the number, put a minus sign in front of it. 2. If your positivie number is in cell A1, enter =-a1 in, say cell b1. 3. If you have a group of mixed numbers (positive and negative), use an IF statement in cell b1. E.g. =if(a1=0,a1,-a1) and copy. "MICHALK" wrote: Thanks...but I was hoping to find a faster way to switch a range. How to change a positive number to negative? |
|
Thread Tools | |
Display Modes | |
|
|