Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

how calculate compounding intere

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to calculate compounding interest on a monthly basis

How to calculate compounding interest on a monthly basis

ResolvedVersion 2007

Mabel has attended:
Excel Advanced course
Access Intermediate course

How to calculate compounding interest on a monthly basis

i would appreciate a template to use in calculating compounding interest on a monthly basis

Edited on Thu 18 Sep 2008, 12:39

RE: how to calculate compounding interest on a monthly basis

Hi Mabel

Interestingly Excel does not have a built in function for compounding interest but there is a useful resource on their website that shows how you can get round this.

Please see the following link:
http://support.microsoft.com/kb/141695

Hope that helps.

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.