ISPMT function
Excel » Functions » Financial » ISPMT function »
The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]
The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup