What formula can you use to compound monthly returns?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

someone please shorten this formula... 6
Conditional formatting multiple cells from one cell to another 3
Expanding Date formula 1
= cell above last entered data 8
Use Formula from another worksheet 3
how to auto increment cell location within formula 3
Junp start my Select Case Macro 12
Daily compound interest 2

Top