When entering a formula for a mortgage payment the formula displays a
negative number. How do I get it to display a positive number for the
monthly payment.
When entering a formula for a mortgage payment the formula displays a
negative number. How do I get it to display a positive number for the
monthly payment.
Originally Posted by =?Utf-8?B?c2Ft?=
=(monthly_payment_amount)*(-1)
OR
=(your_monthly_payment_formula)*(-1)
will both give you a positive number.
BenjieLop
Houston, TX
Sam,
Simply put a minus sign in front of the formula:
=-pmt(xx,yy,zz)
=Mac=
"sam" <[email protected]> wrote in message
news:[email protected]...
> When entering a formula for a mortgage payment the formula displays a
> negative number. How do I get it to display a positive number for the
> monthly payment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks