=PRODUCT(1+C4:C6)

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



"Legan002" wrote in message
...
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.