Excel 2007 : Compounding Returns

I am looking for excel function which does this :
Excel_function(r1,r2,r3,r4 ....) = (1+r1)*(1+r2)*(1+r3)*(1+r4) .... - 1


Here are more details about the requirement.

I have "simple" returns data for successive month and I want to put them together (sort of compound them together) to get yearly return. In other words, I have following returns data

>>Simple Return for first period
r1[0,1] = profit1/month1

On similar lines,
r2[1,2] = profit2/month2
<< Note that month2 is NOT EQUAL to (month1+profit1)
....
r3[2,3]
r4[3,4]
r5[4,5]

Expected Result on giving the input of these returns :

Output = R = (1+r1)*(1+r2)*(1+r3)*(1+r4)*(1+r5)-1

I can always right a macro where the range is the input and I put that range in this formula (using "for" loop) to get the necessary result, however, I prefer to do it using excel formulas.

Welcome to the forum.

Perhaps =PRODUCT(1 + R1:R5) - 1, which MUST be confirmed with Ctrl+Shift+Enter.