Thread: make a positive number to negative
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default make a positive number to negative
Sun, 30 Mar 2008 13:30:00 -0700 from D :
How can I make a positive number in cell say B12 turn to a negative number
in cell B18?

In cell B18 put
=-B12

If B12 is negative that will make B18 positive. If you want B18 to be
negative whether B12 is positive or negative, put this in B18:
=-ABS(B12)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
Reply With QuoteReply With Quote