|
|
#3
10-14-2013, 10:55 PM
|
||||
|
||||
With the mortgage in A1, Annual Interest Rate as a % in B1, Monthly Instalment in C1, the formula for calculating the number of months to pay off the mortgage is:
=NPER(B1/12,-C1,A1,0,0) For your data, the result is 463.14 months.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to do Calculations In a Text Box? | SteveF | Word | 4 | 09-27-2013 08:34 AM |
 Using Reference Tables in calculations
|
BritBiker2 | Excel | 5 | 02-15-2013 04:19 AM |
|
Perform Calculations using List boxes
|
Jennifer_Falcon | Word VBA | 6 | 07-26-2011 10:49 AM |
|
Can I do calculations with times?
|
cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |
|
Having problems with Duration calculations.
|
bgane | Project | 1 | 03-20-2006 06:36 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode