use a - in front of or inside the formula

Signature
Don Guillett
SalesAid Software
donaldb@281.com
> I'm using the PMT function to do some financial planning, but everytime I do
> a calculation for a payment it comes up as a negative number.
[quoted text clipped - 5 lines]
>
> ed
Hi BigBlueMan!
Either:
Use =-PMT(........)
Or:
Reverse the signs of the PV and FV arguments.

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
> I'm using the PMT function to do some financial planning, but
> everytime I do
[quoted text clipped - 7 lines]
>
> ed
BigBlueMan - 01 Apr 2004 16:28 GMT
Thank you gentlemen! Works like a charm!
Ed (Kentucky, USA)
> Hi BigBlueMan!
>
[quoted text clipped - 17 lines]
> >
> > ed
Norman Harker - 01 Apr 2004 16:46 GMT
Hi Ed!
Thanks for thanks is always appreciated and helps Google searchers
know that solutions work "as advertised". I know Don appreciates being
called a Gentleman for a change. <vbg>

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
> Thank you gentlemen! Works like a charm!
>
[quoted text clipped - 22 lines]
>> >
>> > ed
Don Guillett - 01 Apr 2004 17:18 GMT
What's a gentleman? We don't have those in Texas.

Signature
Don Guillett
SalesAid Software
donaldb@281.com
> Hi Ed!
>
[quoted text clipped - 28 lines]
> >> >
> >> > ed
Don Guillett - 01 Apr 2004 17:18 GMT
glad to help

Signature
Don Guillett
SalesAid Software
donaldb@281.com
> Thank you gentlemen! Works like a charm!
>
[quoted text clipped - 21 lines]
> > >
> > > ed
Norman Harker - 01 Apr 2004 16:34 GMT
Hi BigBlueMan!
I should add that where you have arguments for both the PV and FV it
is important that you switch both of their signs. The function is
calculating the PMT that balances the equivalence formula and failure
to switch both signs would throw this out.
Using the switched sign approach is the same as reversing your
"persona". From being a borrower to whom the PV is an amount received,
you become a lender to whom the PV is an amount paid out. Similarly
with the FV argument. From being a borrower who pays out a terminal
payment, you become a lender who receives the terminal payment.
On balance I prefer a sign convention approach but simple negating of
the entire function will do the job.

Signature
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
> Hi BigBlueMan!
>
[quoted text clipped - 17 lines]
>>
>> ed