Think CUMIPMT requires the Analysis ToolPak (ATP) to be installed and
enabled. The advisory below was pasted from Excel's Help for CUMIPMT :

".. If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu."

Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Toni" wrote in message
...
I'm trying to use the CUMIPMT function, but keep getting an error #NAME%,
what am I doing wrong. I've pasted it exactly from the previous tread, do
I
need to download the function into excel?