Tech Support Guy banner
Cancel

Help with excel PMT and Average

3088 Views 11 Replies 3 Participants Last post by  The Villan, 
D
Hi all I am using Excel and i am trying to work out how to do the following:


I am doing a Excell excersize for college (to be handed in when we return) and I have to use the 'PMT' function to calculate the monthly repayments of a loan in the spreadsheet - How is this done. MS Online does'nt seem to be very helpful :S

with my calculations () It has came up with -£132 per month as payment which is obviously not right can anyone advise on the formula I shound be entering the spreadsheet states:

Loan amount £10,000
No. of Years 10
Annual interest rate 10%
Monthly repament = ?

The other problem with another spreadsheet i am having is I don't know how to get the average of something AND round it to the nearest whole number can anyone advise on how this would be done ?

Thanks
Save
Like
Status
Not open for further replies.
1 - 2 of 12 Posts
D
Hi there again everyone ) I managed to with help here and learning about the functions I managed to get this paper done :) Glad theres a site for things like this don't know what I would have done otherwise.

and as for the query about whether or not I am allowed to as for help I found out about this and It is ok for me to receive advice and explanations as long as it isnt blatently just being done for me.
Save
Like
1 - 2 of 12 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top