Compound Interest Rates (SUM)

[Galopes]

Hi guys,

I need your help with something...

I'm trying to create a function based on a sum of the compound interest rates. But I have no idea how to do it.

The function is very simple (I've called of SUMINTR), it just need to do this action: [(1+X1)*(1+X2)...*(1+Xn) - 1]. So for instance, if I have 3 interest rates (1%,2%,3%) the function will give me 6,1106%. Got it?

If you guys have some thoughts, please, let me know!

[hrlngrv]

You mean

Please Login or Register  to view this content.

?

[Galopes]

HOLY JESUS! That is it!! You can't even imagine how long time I am trying to find this function! I thought that I will be needed to create a new function on VBA! My mind was so exhausted that I forgot the basic math to make this simple function work! Much obliged!!