PDA

View Full Version : Solved: Changing a minus to a plus



Tenspeed39355
01-19-2006, 09:01 AM
I have a column of numbers that have a minus sign in front -30. I need to make the -30 to be 30 or can I change the whole column at the bottom of the column?
Thanks
The numbers are the result of a formula that makes the numbers in the column
all minus.
Thanks for your help
Max

Philcjr
01-19-2006, 09:05 AM
Max,

In a column next to your "-30" (Say it is A1).

I would place in cell B1 a formula =ABS(A1) and copy it down. This will give you the Absolute value for A1.

Or if cell A1 has a formula, get the ABS(insertyourformulahere)
right from the start

Why do you want to remove the " - ".

Phil

Norie
01-19-2006, 09:44 AM
Max

Why not change the formula to return +ve numbers instead of -ve numbers?

Tenspeed39355
01-19-2006, 11:43 AM
Phil I am constructing the RSI formula to show the relitive streigth index of a fund price.
The column that has the minus numbers is the result of the market price from one day to the next. If the mkt price when up the positive number up goes in column B. If the mkt goes down the negitive goes in column C. Excel puts a minus sign in front of the number.
The minus number has to be removed before any more calulations are made. Do you have
thing else that I could use?
Max

Philcjr
01-19-2006, 11:48 AM
What if you multiply your number by a negative one?

A neg x a neg = a pos

If this will not work, give us a few examples of data or post the formula you are using

Steiner
01-27-2006, 12:21 AM
Maybe you could do the * -1 right when you divide the values into the 2 columns, like in this example.

Daniel

Tenspeed39355
01-27-2006, 06:42 AM
Thanks that will work
Max