What formula can you use to compound monthly returns?

L

Legan002

Instead of typing ((1+C4)*(1+C5)*(1+C6))-1 is there a formula I can use say
=compound(c4:c6) to get what I need? You would think that would be an
extremely helpful formula.
 
P

Paul Corrado

=PRODUCT(1+C4:C6)

Entered as an array formula by holding down CTRL+SHIFT when pressing ENTER
 
Top