You didn't say how you
setup your test spreadsheet, but since IPMT is
defined as «calculates the interest payment,
during a specific period of a loan or investment that is paid in constant periodic payments, with a constant interest rate,» (emphasis added) I think you could be making mistakes in how you use it.