Cell Copy and Paste to another cell, opposite sign (+/-)

Hi Group,

Need some help on this issue.

Need to make a formula or if anyone knows a way to do this without a formula, great!

Problem:

Need to take a value from one cell(x) and paste in another(y). The kicker is, anytime a value is input into cell x, I need it to take that value and reverise the positive or negitive sign.

Example: Cell x = 32, would like cell y to = -32
Example: Cell x = -122 would like cell y to = 122

Any Ideas?

Thanks

In your destination cell, you can just put a reference to the the first cell and negate it. So if A1 = 10, then in cell A2, you can put "=-A1". Is that what you meant? Or is it more complicated than that?

Ok, that would work, but what if the value in X is negitive? Would that go ahead and make it positive by canceling out the negitive sign?

Ok,

I'll try it.

What does the ABS mean?


=IF(A1 < 0, ABS(A1), -A1)

Cool!

I'll give it a try.