IRR
MDURATION
About This Document
The Gnumeric Manual, version 1.8
Welcome!
How to Use this Manual
A Quick Introduction
Gnumeric Elements
Working with Data
Advanced Analysis
Graphics: Plots, Images, Widgets, and Drawings
Configuring Gnumeric
Working with Files
Printing
Getting More Help
Reporting a Problem
Extending Gnumeric
Function Reference
Bitwise Operations
Complex
Database
Date/Time
Engineering
Erlang
Finance
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUM_BIV_NORM_DIST
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
EURO
EUROCONVERT
FV
FVSCHEDULE
G_DURATION
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OPT_2_ASSET_CORRELATION
OPT_AMER_EXCHANGE
OPT_BAW_AMER
OPT_BINOMIAL
OPT_BJER_STENS
OPT_BS
OPT_BS_CARRYCOST
OPT_BS_DELTA
OPT_BS_GAMMA
OPT_BS_RHO
OPT_BS_THETA
OPT_BS_VEGA
OPT_COMPLEX_CHOOSER
OPT_EURO_EXCHANGE
OPT_EXEC
OPT_EXTENDIBLE_WRITER
OPT_FIXED_STRK_LKBK
OPT_FLOAT_STRK_LKBK
OPT_FORWARD_START
OPT_FRENCH
OPT_GARMAN_KOHLHAGEN
OPT_JUMP_DIFF
OPT_MILTERSEN_SCHWARTZ
OPT_ON_OPTIONS
OPT_RGW
OPT_SIMPLE_CHOOSER
OPT_SPREAD_APPROX
OPT_TIME_SWITCH
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
Gnumeric
Information
Logic
Lookup
Mathematics
Number Theory
Random Numbers
Statistics
String
Keybinding Reference
ISPMT
The Gnumeric Manual, version 1.8
Function Reference
Finance
ISPMT
—
Synopsis
Description
Examples
See also
Synopsis
ISPMT
(
rate
,
per
,
nper
,
pv
)
Description
ISPMT
function returns the interest paid on a given period.
If
per
< 1 or
per
>
nper
,
ISPMT
returns #NUM! error.
Examples
See also
PV
.
IRR
MDURATION