Reverse the sign of a number in a cell
I'd like to create a formula that I can use to reverse the sign of a number.
The problem I'm having is that the formula cannot contain a reference to the
cell itself because it then loses the value. I realize that I can do this
through VBA, but I wondered if there was another way to do this. It seems
like this would be a fairly common thing to do.
Thanks in advance for your help!
|