PMT Function is comig up as a negative, when it should be a positive

[potsie via OfficeKB.com]

My PMT function is coming up as a negative figure, when it should be a
positive one and I can't for the life of me figure out how to put round into
this function. Ex: PMT .05% 12months I4 (cost) 2 decimals.
thanks for help out there

--
Message posted via http://www.officekb.com

[[email protected]]

"potsie via OfficeKB.com" wrote:
> My PMT function is coming up as a negative figure,
> when it should be a positive one

There is nothing wrong with PMT(). If PV is positive,
PMT must be negative. Conversely, if you want PMT
to be positive, simply make PV negative.

> Ex: PMT .05% 12months I4 (cost) 2 decimals.

=PMT(0.05%, 12, -I4)

But I wonder if 0.05% is the monthly rate (only 0.6%
annually!?), or if you mean 5% annually -- in which case,
you want to write 5%/12.

[7$!]

You add to your formula *-1 and your PMT will not give a negative result. Just times -1 at the end of your PMT formula

[popipipo]

I don't think potsie via OfficeKB.com is waiting for a answer after more then 9 years

[FDibbins]

7$!, welcome to the forum

You may not have noticed, but this thread is almost 10 years old (good suggestion though)