One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=PRODUCT(1+A1:An)-1

In article ,
George wrote:

HI,
Could you let me know if there is an Excel function that calculates the
below formula:
List of percentages in column A, with the answer I want at the end of the
column is as follows:
[ (1+A1) x (1 +A2) x ...(1+An) ] -1
i have tried SumProduct but this does not work.
Thanks
George