mustard

By formula in A1 enter =b1*-1

where b1 is negative or positive.

Without a formula enter -1 in any empty cell then copy and select cells to
change then Paste SpecialMultiplyOkEsc on all selected cells.


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 13:52:43 -0500, mustard
wrote:


I would like to know if there is any way to have a formula/function that
takes a value from another cell (I know how to do that part) and then
makes the number negative if the original is positive - or else makes
the number positive if the original is negative. Any ideas?