| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a positive number to negative
How can I make a positive number in cell say B12 turn to a negative number
in cell B18? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
make a positive number to negative
In B18:
=-B12 -- Kind regards, Niek Otten Microsoft MVP - Excel "D" wrote in message ... | How can I make a positive number in cell say B12 turn to a negative number | in cell B18? | | thanks | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
make a positive number to negative
In B18, put the formula =-B12.
-- David Biddulph "D" wrote in message ... How can I make a positive number in cell say B12 turn to a negative number in cell B18? thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
| Format cells to change a number from a positive to negative | Excel Worksheet Functions | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Easy way to make negative data positive? | Charts and Charting in Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Hybrid Mode
