Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating and adding custom formulas | Excel Worksheet Functions | |||
Creating a Custom Form | Excel Discussion (Misc queries) | |||
Creating custom charts | Charts and Charting in Excel | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
Creating an custom input box | Excel Worksheet Functions |