make a positive number to negative

D

D

How can I make a positive number in cell say B12 turn to a negative number
in cell B18?

thanks
 
N

Niek Otten

In B18:

=-B12

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How can I make a positive number in cell say B12 turn to a negative number
| in cell B18?
|
| thanks
|
 
S

Stan Brown

Sun said:
How can I make a positive number in cell say B12 turn to a negative number
in cell B18?
Click to expand...

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
Linking Equations to Highlights 2
If Then Help 3
Counting consecutive negative value 7
Excel VBA to match positive and negative transactions 3
Postive # converted to Negative # 7

Top