Hi,

I am trying to find the interest payment on a mortgage for each year of up to a 30 year mortgage. When I put the CUMIPMT formula in, I get the #REF error. I get this error even if I put actual values in for all the variables (pv, nper, fv etc.) not just cell references. I even tried the values they give in the example in the Help section and get the same error. I am running Excel 2003. Any help would be much appreciated. Thanks.