berekenhulp

This is the shortcode that I am using:

[a-z-listing display="posts" post-type="page" exclude-posts="2832,1021,3112,322,2498,3238,2500,304,2891,3176,713,3203,1980,1989,1986,1999,1977,1983,1993,1996"]

Edit: Sorry, placed the CSS on the wrong place. Does work now.

Daniel, thanks for your answer. That’s very nice! I’m going to try it today. Thanks a lot

Wow! So much thanks for your response

But when I’m using MS Excel, using the formula beneath, it gives another result.

B2/1(1-(1+B4/100)^(1/12))+(B2-B2/(1-(1+B4/100)^(1/12)))*(1+B#/100)^B3-B2 = 153121,8183

B2 = monthly investment
B3 = duration in years
B4 = yearly interest rate

I don’t understand the problem. Can you please help me out?

When i’m using the POW equation in my formula it doesn’t work.

My question: I would like to calculate my final capital with the following conditions: monthly investment of €300, yearly interest rate of 7% and a duration of 20 years. I use the following formula:

Fieldname2/
(1-POW((1+fieldname4/100),(1/12)))
+
(fieldname2-fieldname2/(1-POW((1+fieldname4/100),(1/12))))
*
POW((1+fieldname4),fieldname3)-fieldname2

I don’t get any result but it should be 153121,8183

Fieldname 2 = monthly investment
Fieldname 3 = duration in years
Fieldname 4 = yearly interest rate

Can you please help me? Thanks in advance

• This reply was modified 7 years, 4 months ago by berekenhulp.

Thanks! I didn’t think of this solution. Great ??

But why does it require 2 fields? I’m looking for something that works like square.
For example:
SQR(2) = 4
SQR(3) = 9