Here is my problem in Excel: This is a recurrence problem. I was doing the Capital Growth which calculates the amount of the investment as it is compounded by the addition of interest for each period.

here is the formula:
=IF(ISNUMBER(Period(C3*(1+Interest_Rate*Interest_P eriod))),"")

here is the outcome:
Period Capital
0 $30,000.00
1 FALSE
2
3 FALSE
4 FALSE
5 FALSE
6 FALSE
7 FALSE
8 FALSE
9 FALSE
10 FALSE
11 FALSE
12 FALSE
13 FALSE
14 FALSE
15 FALSE
16 FALSE
17 FALSE
18 FALSE
19 FALSE
20 FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE

This is the parameter:
Initial Capital:$30,000
Investment Date: 1/31/1993
Maturity Date:1/31/2003
Interest Rate:8.00%
Interest Period:0.5

Term:10.00
Number of Periods:20

I want the capital growth be visible ONLY to the period corresponding to it. i dont know what is wrong with my formula becuase it is saying FALSE..

Thanks for the help in advance.