Reversing Positive and Negative Values - Possible?

Hi guys.


I have a spreadsheet with positive and negative numbers on it.

I need to reverse the values...so that the positives are now negatives...and the negs - positive.


Is there a way to do this?



Thanks so much!!
Jenny

Originally Posted by JennyW

Hi guys.


I have a spreadsheet with positive and negative numbers on it.

I need to reverse the values...so that the positives are now negatives...and the negs - positive.


Is there a way to do this?



Thanks so much!!
Jenny

Hi Jenny,

A simple example

A1 = -25
A2 = A1*-1
Result = 25

or visa versa

If you need more help, let me know

oldchippy

Hi...wow...that worked great for the positives to trans in to negs...but how to I made the negatives turn in to positives!??


Not the greatest at math....eek!


Thanks.

Nevermind...not thinking straight this am....


Did what you said for all....thanks so much!! Life saver!!

See you are good at Maths

Yeah, that's pretty cool too!!

Thanks guys!!! I like the second one too!! Thanks again guys!!