Spread Formula Reference
Financial Functions
Formula Overview > Functions in a Formula > Categories of Functions > Financial Functions

The functions that relate to financial calculations such as interest calculations are:

ACCRINT ACCRINTM AMORDEGRC AMORLINC
COUPDAYS COUPDAYBS COUPDAYSNC COUPNCD
COUPNUM COUPPCD CUMIPMT CUMPRINC
DB DDB DISC DOLLAR
DOLLARDE DOLLARFR DURATION EFFECT
EUROCONVERT FV FVSCHEDULE INTRATE
IPMT IRR ISPMT MDURATION
MIRR NOMINAL NPER NPV
ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD
PDURATION PMT PPMT PRICE
PRICEDISC PRICEMAT PV RATE
RECEIVED RRI SLN SYD
TBILLEQ TBILLPRICE TBILLYIELD VDB
XIRR XNPV YIELD YIELDDISC
YIELDMAT      

For the financial functions that use it, refer to Day Count Basis.

Return to the list of Categories of Functions.

For the arguments of some of these functions and for the results of some of these functions, money paid out is represented by negative numbers and money you receive is represented by positive numbers. How the currency values are displayed depends upon how you set up the cell type and the format settings.