# Change neg to pos

#### 3way

##### New Member
I am creating an amortization-type spreadsheet to analize real estate investments. I can't figure out how to change a negative number (p&i amount on a loan) to a positive number to use in another formula (i.e. adding p&i to taxes and insurance for a total payment).

Thanks!

3way

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
use ABS function, change the value to absolute value.

[No message]

Hi

If your negative value is in cell A1 use thisA1*-1)+?+? where ? are your other values.
This message was edited by royUK on 2002-09-13 23:19

=SUM(ABS(A1),B1,C1)

Where A1 houses the negative value.

"Why not merely = -A1 + ? + ?"
In my case I'd be adding a negative number (principal & interest) to two positive numbers. That gives me the wrong answer.

Thanks to everyone for all the great answers. I was almost too embarrased to ask but I'm so glad I did!

Cordially,

3way

Unless someone's cracked my password, the moderator has deleted the messages that I previously posted to this thread.

The deletions have been done without any notification and without providing any reason.
If the moderator is responsible, then I think it is a very ill-mannered way to behave.

If the moderator sees fit to delete this message also, I would hope that he will do so with more courtesy than the last time.

Naturally, I withdraw all criticism if he was not the one who deleted my posts, or he did so in error.

I will repeat the gist of the last post I made :-

You said that your number (assumed to be in A1) is always negative.
Therefore, using = -A1 will convert the number in A1 to a positive value (since 2 negatives equal a positive!).
It does the same as the other solutions that you seem to be happy with =(A1*-1), =ABS(A1), and it's a bit shorter.

Replies
3
Views
410
Replies
1
Views
484
Replies
4
Views
405
Replies
5
Views
881
Replies
4
Views
434

1,219,579
Messages
6,149,099
Members
450,859
Latest member
njaitley

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back