ISPMT

This function calculates the interest paid during a specific period of an investment.

ISPMT(rate,per,nper,pv)

This function has these arguments:

Argument	Description
rate	Interest rate for the investment.
per	Number of the period for which to find the interest, between 1 and nper.
nper	Total number of payment periods for the investment.
pv	Present value of the investment.

Be consistent with the units for rate and nper.

The cash you pay out is represented by negative numbers and the cash you receive by positive numbers.

Accepts numeric data for all arguments. Returns numeric data.

ISPMT(B1,C4,C5,1)

ISPMT(R1C2,R4C3,R6C3,R7C3)

This function is available in product version 2.0 or later.