PRODUCT series excel vba

[sandradepar]

Hi,
Can someone help me?
I don't know how to solve this problem: find the product of a series

from i=1 to n, where X(i)= b -(n- i )* (r) and r=( (X-X(1)))/n
Lets suppose that n=25 and b=2, X(1)= 0,1472, X(25)=2 and r=0,772
Can someone show us the easiest way how to solve for product of a series by using a code for vba ?

Many thanks in advance

 

[sandradepar]

Hi,
Can someone help me?
I don't know how to solve this problem: find the product of a series (see the picture bellow)
PRODUCT



from i=1 to n, where X(i)= b -(n- i )* (r) and r=( (X( n )-X(1)))/n
Lets suppose that n=25 and b=2, X(1)= 0,1472, X(25)=2 and r=0,772
Can someone show us the easiest way how to solve for product of a series by using a code for vba ?

Many thanks in advance