Apache OpenOffice Calc Functions
From Apache OpenOffice Wiki
Revision as of 00:23, 22 June 2013 by Javier Lopez (talk | contribs)
This is a user-generated collection of Wikibooks pages that can be easily saved, rendered electronically, and ordered as a printed book. If you are the creator of this collection and need help, see Help:Collections. |
Calc Functions
- Arrays Functions
- Frequency
- Growth
- Linest
- Longest
- Mdeterm
- Minverse
- Mmult
- Munit
- Sumproduct
- vSumx2my2
- Sumx2py2
- Sumxmy2
- Transpose
- Trend
- Complex Number functions
- Complex
- Imabs
- Imaginary
- Imargument
- Imconjugate
- Imcos
- Imcosh
- Imcsc
- Imcsch
- Imcot
- Imdiv
- Imexp
- Imln
- Imlog10
- Imlog2
- Impower
- Improduct
- Imreal
- Imsec
- Imsech
- Imsin
- Imsinh
- Imsqrt
- Imsub
- Imsum
- Imtan
- Data & Time Functions
- Today
- Now
- Year
- Month
- Day
- Weekday
- Hour
- Minute
- Second
- Date
- Datevalue
- Time
- Timevalue
- Eomonth
- Edate
- Workday
- Networkdays
- Days
- Days360
- Daysinmonth
- Daysinyear
- Weeks
- Weeksinyear
- Weeknum
- Weeknum_add
- Months
- Years
- Isleapyear
- Eastersunday
- Yearfrac
Depreciation
Payment Streams, Annuities, Loans
- Cumipmt
- Cumipmt Add
- Cumprinc
- Cumpinc Add
- Fv
- Fvschedule
- Ipmt
- Irr
- Ispmt
- Mirr
- Nper
- Npv
- Pmt
- Ppmt
- Pv
- Rate
- Rri
- Xirr
- Xnpv
Securities
- Accrint
- Accrintm
- Disc
- Duration
- Duration Add
- Effective
- Effect Add
- Intrate
- Mduration
- Duration Add
- Nominal
- Nominal Add
- Oddfprice
- Oddfyield
Coupons
Miscellaneous