Reverse + and - signs
hi
not a built in function. traditionally this is usually accomplished by
simple multipling by a negative one. say your number are in column A.
=A1*-1
if 5 were in A1, the formula would return -5, thus changing the sign of the
number from positive to negative and vice versa.
Regards
FSt1
"C" wrote:
I have a sheet that I need to show my negatives as positives and vice versa.
Is there a function that can perform this for me?
|