Change Sign formula in Excel

[getitdaily]

I've looked through all the formulas and I may have overlooked it, but....

Is there a formula in Excel that changes the sign of a number in a cell???

 

[carrr]

Change sign? Meaning from + to -??
If so, highlight cell(s), right click, Format Cells, Number, Custom, -#.

 

[247]

To change the sign, just multiply it by negative 1.
Also, there is a SIGN function.

 

[getitdaily]

If the sign is + change it to -, if the sign is - change it to +

 

[getitdaily]

multiply by -1, so simple, yet so far away.


Thanks,