LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anita
 
Posts: n/a
Default Calculate Term

In Excel I know how to calculate a monthly repayment using PMT but is there
any way I can calculate how long a loan would take to pay off )this is a
question I've been asked and I'm not sure whether it can be done or not).

I thought maybe goal seek but you can only use that on a cell containing a
formula.

Any ideas gratefully received.

Many thanks

Anita
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calculate Hours and overtime by week gregt812 Excel Worksheet Functions 1 November 23rd 05 07:03 PM
how to calculate a cube root kiran Rajguru New Users to Excel 2 November 16th 05 10:50 AM
Spreadsheet Won't Calculate Scott Excel Discussion (Misc queries) 0 September 29th 05 05:37 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Not able to calculate. mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 08:55 PM


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"