View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
axr0284 axr0284 is offline
external usenet poster
 
Posts: 4
Default Creating a custom formula

Hi,
I am a newbie at excel so I would like to know How to do the following.
Cell A1 would contain 1 date A
Cell A2 would contain a second date B
Cell A3 would contain a number X
Cell A4 would contain a number Y
I would like cell A5 to contain a formula that will perform the following
recursively:
Sum[F(n-1)+{F(n-1)*Y}] for n = 1 to (B - A) and F(0) = X

so if n = 1 to 20, it would iterate 20 times first using X and then the that
result in the next iteration and so on until n=28. Then it would display the
final result in cell A5.

I have not been able to figure out how to do this. Thanks for any help,
Amish