Reverse values
Posted by Todd on February 04, 2002 7:31 AM
I have a large spreadsheet where all numbers are positives. I have to transfer this information to another spreadsheet where a large part of these numbers need to be shown as negatives. Is there a way to reverse the value of these cells automatically?
Posted by Carl B on February 04, 2002 8:25 AM
Need more info, what would the criteria be to reverse the numbers as you stated not all the numbers would be reversed.
You can always times the result by -1 to reverse a number. I.E. =A2*-1, =$A$1*-1, or =Sheet2!A1*-1
Posted by Mark W. on February 04, 2002 3:46 PM
Don't forget that - is also a unary negation operator...
...so, these work also...
=-A2, =-$A$1, or =-Sheet2!A1
