What is "it" that you want calculated? The rate of return earned? If so, use
XIRR.

Regards,
Fred.

"Robert Blass" wrote in message
...
Allow me and permit me to explain more better.


It started @ $44 and is NOW @ $1,600 in just 10 months.

What would it have been IF I had contributed $108 per month for all 10
months so far?


thanks all......













On Fri, 10 Oct 2008 21:24:48 -0400, "Bernie Deitrick" <deitbe @
consumer dot org sayd the following:

Robert,

With the Annual interest rate in cell A1 (Entered as a percent)

=FV(A1/12,10,-100,-50)

Interest earned would be that - 1050.

HTH,
Bernie
MS Excel MVP


"Robert Blass" wrote in message
. ..
Starting with $50.
Contributing exactly $100 per month every month for 10 months

Formula would be?


using excel 97'