| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound interest
Hi
I am trying to work out compound interest between two dates. What I have so far is this: cell content ______________________ A1 todays date A2 a date in the past A3 function to work out the number of days between the two dates ( I am using DAYS360 ) A4 A3/365 (to change to years) A5 Amount of money, say, 50 This is the bit I am having trouble with, the formula for compound interest A6 A5(1+0.08)^A4 I keep getting #REF! Can anyone help me please :) Robert |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compound interest
A5*(1+0.08)^A4
rather than A5(1+0.08)^A4 -- Gary's Student "Robert Tracey" wrote: Hi I am trying to work out compound interest between two dates. What I have so far is this: cell content ______________________ A1 todays date A2 a date in the past A3 function to work out the number of days between the two dates ( I am using DAYS360 ) A4 A3/365 (to change to years) A5 Amount of money, say, 50 This is the bit I am having trouble with, the formula for compound interest A6 A5(1+0.08)^A4 I keep getting #REF! Can anyone help me please :) Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to figure compound interest of a deposit for a year | Excel Worksheet Functions | |||
| how do I calculate the annual interest when I know the compound | Excel Worksheet Functions | |||
| compound interest | Excel Worksheet Functions | |||
| Compound interest calculation | Excel Discussion (Misc queries) | |||
| Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
Linear Mode
