Let's see...

Break it up into it's components:

(1+d) is one component
i is a looping Long Integer

Dim i As Long, n As Long, s As Long, d As Long
Dim z As Long, tot As Long

n = 10 ' set this to whatever you like
For i = 1 to n
tot = tot + s * ( 1 + d ) ^ ( i - 1 ) * ( 1 + z ) ^ ( n - i + 1 )
Next i

It's been a long time since I've seen such but is that from an
elementary integral calculus class ? If I remember correctly, I
think I started learning that kind of math in a pre-calc class,
before the introduction into the concepts of approaching
infinity.

I can see that the formula you provided is not plotting a graph,
unless most of those other variables are constants.

If you could let me know, I'm curious about what the variables
represent.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


"Manfred" wrote:
Hi everybody,

how can I program that formula in Excel :

thank in advance
manfred