"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?