CUMIPMT function error

[MichaelJ]

I have excel 2003. I sent via email a worksheet to my office.
It is a worksheet that calculates various rates of return, NOI, CAP rates,
Return on Cash, etc.

Now when I make a change of any kind, the 'INTEREST' cell displays "#NAME".

I have done the 'tools', 'add-ins', 'Analysis Tool-Pak', and it does show
the items checked.

I still cannot get this to work. I even shut down the computer and
restarted, thinking it needed to 'apply', but to no avail.

HELP!!

 

[Ron Rosenfeld]

I have excel 2003. I sent via email a worksheet to my office.
It is a worksheet that calculates various rates of return, NOI, CAP rates,
Return on Cash, etc.

Now when I make a change of any kind, the 'INTEREST' cell displays "#NAME".

I have done the 'tools', 'add-ins', 'Analysis Tool-Pak', and it does show
the items checked.

I still cannot get this to work. I even shut down the computer and
restarted, thinking it needed to 'apply', but to no avail.

HELP!!

What is the formula in the INTEREST cell?
What is the contents of the INTEREST cell precedents?
--ron