Problem with CUMIPMT function

[marcin.msg]

Hello everybody!

I have a problem with CUMIPMT function in excel 2010. Although I have Analysis ToolPak activated it still shows #NAME error instead of calculating my formula.

Can You help me to solve it?

marcin.msg

 

[snoopyhr]

is it setup like this ?

Excel Workbook
	A	B
1	Data	Description
2	9%	Annual interest rate
3	30	Years of the loan
4	125,000	Present value
5	Formula	Description (Result)
6	-11135.23213	Total interest paid in the second year of payments, periods 13 through 24 (-11135.23)
7	-937.5	Interest paid in a single payment in the first month (-937.50)
Sheet1

another problem could be you need to close excel after addin activated and reopen it . other than that I do not know what could cause the name error.

 

[marcin.msg]

Yes, it looks just like you showed it.

Actually I've found a solution: this formula is translated to ma native language in excel 2010. I've noticed that when I opened an example file with that formula.

Thanks!