# Negative vs Positive?

#### JJ in SD

##### Active Member
Good morning,

Why does this formula =PMT(4.25%/12,60,10000) return a negative
(-185.30) instead of a positive (185.30) result, and how do I correct it?

JJ in SD

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Zack Barresse

##### MrExcel MVP
=abs(reference) will give you the positive interger value of the reference - always positive.

HTH

#### JJ in SD

##### Active Member
Thank you very much Firefytr, JJ

##### MrExcel MVP
firefytr said:
=abs(reference) will give you the positive interger value of the reference - always positive....

Given that PMT always returns a neg figure:

=-PMT(4.25%/12,60,10000)

which means one less function call

#### Juan Pablo González

##### MrExcel MVP
And just to give a little background on why it returns a negative amount...

Assuming that scenario that you have, consider that you're applying for a loan, and the bank gives you \$1000.

Now, in YOUR balance, you see a credit of +1000, correct ?

Now, the bank tells you, ok, every month you must pay 185.30.

What that means is that in YOUR balance, you'll have a debit o 185.30, correct ? that, mathematically, represents -185.30, to "compensate" for the +1000 that you received.

If you changed the formula to

=PMT(4.25%/12,60,-10000)

where -10000 represents for example, an investment (A debit in your balance), Excel would return

+185.30

, in other words, the earnings of that investment, positive, to "compensate" for the investment.

Does that help ?

Replies
2
Views
92
Replies
1
Views
133
Replies
1
Views
494
Replies
6
Views
127
Replies
3
Views
84

1,172,044
Messages
5,878,875
Members
433,380
Latest member

### 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