geometrically linking financial returns

[dviall]

I need to add "1" to each percentage in a series, then calculate the product of the series. What I need to do is almost of opposite order of the sumproduct function that multiples first, then adds. I want to add the 1 first, then multiply. Thanks for your help.

 

[Mark W.]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	9.17%		49.12287
2	40.30%
3	13.08%
4	86.50%
5	75.04%
6	65.40%
7	17.58%
8	82.13%
9	59.39%
10	53.89%
11
Sheet1

Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula. For more on array formulas see the Excel Help topic for "About array formulas and how to enter them".