How to calculate the product of a range when each value is added to a constant

[roscoe]

I have a range of percentages in Column A, and want to calculate the product of each of those percentages added to one
ex:
A1=5%
A2=6%
A3=2%

I want the product of (1+A1)*(1+A2)*(1+A3)

Can I do this without a helper cell where I add one to each value? Looking for this as the number of cell in the range can change

 

[hagia_sofia]

E.g.

=PRODUCT(BYROW(A1:A3,LAMBDA(a,1+a)))

 

[roscoe]

Perfect...never heard of that one, have to research that

 

[StephenCrump]

=PRODUCT(1+A1:A3) will also do it.

 

[Dave Patton]

or either of

T202406a.xlsm
	A		C	D
1	5%
2	6%
3	2%
4
5			1.13526	1.13526
6
3d

Cell Formulas
Range	Formula
C5	C5	=PRODUCT(1+A1:A3)
D5	D5	=FVSCHEDULE(1,A1:A3)