LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating and adding custom formulas A.R. Hunt Excel Worksheet Functions 2 March 28th 07 09:24 PM
Creating a Custom Form Shelia Excel Discussion (Misc queries) 1 December 7th 06 11:29 PM
Creating custom charts Taebaek Charts and Charting in Excel 1 November 27th 06 10:10 PM
Creating custom list with a comma in it barnabel Excel Discussion (Misc queries) 6 January 10th 06 06:14 AM
Creating an custom input box [email protected] Excel Worksheet Functions 1 March 17th 05 03:45 AM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"