Cannot get CUMIPMT to work in Excel
 

Using formula =CUMIPMT(0.0075,360,125000,1,1,0)

Analysis toopak is installed. Please Help!!


Norbert :)



--
Work is good, but it's not that important.

Norbert J wrote...
Using formula =CUMIPMT(0.0075,360,125000,1,1,0)

Analysis toopak is installed. Please Help!!

What result are you getting? A #NAME? error? A wrong number?

What result are you expecting? What are you getting? "Can't get it to work"
could mean a lot of things.

Result should be -937.50 (1st month's interest on 125,000 loan @ 9% APR)

--
George Nicholson

Remove 'Junk' from return address.


"Norbert J" wrote in message
...
Using formula =CUMIPMT(0.0075,360,125000,1,1,0)

Analysis toopak is installed. Please Help!!


Norbert :)



--
Work is good, but it's not that important.

Hi
The correct ans is -937.50 I am getting a # Ref!

Thank you for your prompt reply

Norbert

"George Nicholson" wrote in message
...
What result are you expecting? What are you getting? "Can't get it to work"
could mean a lot of things.

Result should be -937.50 (1st month's interest on 125,000 loan @ 9% APR)

--
George Nicholson

Remove 'Junk' from return address.


"Norbert J" wrote in message
...
Using formula =CUMIPMT(0.0075,360,125000,1,1,0)

Analysis toopak is installed. Please Help!!


Norbert :)



--
Work is good, but it's not that important.

On Fri, 17 Jun 2005 14:29:46 -0700, "Norbert J"
wrote:

Using formula =CUMIPMT(0.0075,360,125000,1,1,0)

Analysis toopak is installed. Please Help!!

Your formula, when pasted into my worksheet, gives an answer of -937.50.

Is that really the formula you have from your worksheet?


--ron

"Norbert J" wrote...
The correct ans is -937.50 I am getting a # Ref!

Thank you for your prompt reply
....

If you're truly getting a #REF! error from the formula

=CUMIPMT(0.0075,360,125000,1,1,0)

[note: all numeric constants], then the only thing I can think of is that
CUMIPMT is used as a defined names with a definition that evaluates to #REF!

Is the formula above your *ACTUAL* formula, or is your actual formula using
cell references for some arguments but you figured you'd simplify it when
posting to the newsgroup?