Just multiply it by -1

example:

=-1*A1

"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?


--
mustard
------------------------------------------------------------------------
mustard's Profile: http://www.excelforum.com/member.php...o&userid=20017
View this thread: http://www.excelforum.com/showthread...hreadid=470855