Posted to microsoft.public.excel.programming

Joyce[_3_] Joyce[_3_] is offline

external usenet poster

Posts: 1

mortgage payment

i need to create a formula for calculating a mortgage payment with out using
the pmt option in excel. I have to be able to calculate both a interest only
payment and a payment including interest depending on the type of loan
selected. I cant use the pmt option because it shows as a - in my approval
cell and I cant have it show that way. please help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mortgage payment calculation	kacky	Excel Worksheet Functions	6	May 14th 09 02:06 AM
mortgage payment	england26	Excel Worksheet Functions	2	November 6th 07 01:16 AM
How to calculate a mortgage payment?	Grd	Excel Worksheet Functions	5	August 28th 07 11:46 PM
Trying to Manipulate a Mortgage Payment (HELP!)	DC	Excel Worksheet Functions	1	February 4th 05 05:49 PM
how do you get a positive number payment with a mortgage payment .	sam	Excel Worksheet Functions	1	February 2nd 05 05:32 AM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us