Excel Compatibility

Excel-compatible functions like SUM, PMT, and more.

Instacalc supports the most common Excel functions (SUM, PMT, etc.). Other tips:

Formulas like =R1 * 3 work. (The leading = isn’t needed, but muscle memory!)
Use row ranges like SUM(R1:R3) as you’d expect

Financial Functions

The full set of Excel-compatible financial functions:

Function	What it computes
`PMT(rate, nper, pv, [fv], [type])`	Periodic loan payment
`IPMT(rate, per, nper, pv, …)`	Interest portion of a given payment
`PPMT(rate, per, nper, pv, …)`	Principal portion of a given payment
`ISPMT(rate, per, nper, pv)`	Interest for a period (simple method)
`PV(rate, nper, pmt, [fv], [type])`	Present value
`FV(rate, nper, pmt, [pv], [type])`	Future value
`RATE(nper, pmt, pv, …)`	Interest rate per period
`NPER(rate, pmt, pv, …)`	Number of payment periods
`RRI(nper, pv, fv)`	Equivalent interest rate for growth
`CAGR(start, end, periods)`	Compound annual growth rate
`PDURATION(rate, pv, fv)`	Periods required to reach a value
`IRR(cashflows…)`	Internal rate of return
`NPV(rate, cashflows…)`	Net present value

Computing…

Statistics Functions

Computing…

Other Excel Functions

Spreadsheet-style tables with per-column totals — the everyday Excel job:

Computing…