Apache OpenOffice Calc Functions
From Apache OpenOffice Wiki
| 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
- Information Functions
- Cell
- Current
- Formula
- Isblank
- Iserr
- Iserror
- Iseven
- Iseven Add
- Islogical
- Isna
- Isnontext
- Isnumber
- Isodd
- Isodd Add
- Isref
- Istext
- N
- Na
- Type
Trigonometric
Hyperbolic
Rounding and remaindersLogarithm/Powers
Bessel functions</div>
Miscellaneous
- Abs
- Combin
- Combina
- Convert
- Convert Add
- Countblank
- Countif
- Delta
- Erf
- Erfc
- Fact
- Factdouble
- Gcd
- Gcd Add
- Gestep
- Iseven
- Isodd
- Lcm
- Lcm Add
- Multinomial
- Product
- Rand
- Randbetween
- Seriessum
- Sign
- Sqrt
- Sqrtpi
- Subtotal
- Sum
- Sumif
- Sumsq
- Number Conversion Functions
- Bin2dec
- Bin2hex
- Bin2oct
- Dec2bin
- Dec2hex
- Dec2oct
- Hex2bin
- Hex2dec
- Hex2oct
- Oct2bin
- Oct2dec
- Oct2hex
- Arabic
- Bahttext
- Decimal
- Roman
Spreadsheet Lookup functions
Spreadsheet Information functions
Other functions
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
- B
- Betadist
- Betainv
- Binomdist
- Chidist
- Chinv
- Chisqinv
- Chitest
- Confidence
- Critbinom
- Expondist
- Finv
- Fisher
- Fisherinv
- Fdist
- Ftest
- Gamma
- Gammainv
- Gammaln
- Gammadist
- Gauss
- Hypgeomdist
- Loginv
- Lognormdist
- Negbinomdist
- Norminv
- Normdist
- Normsinv
- Normsdist
- Permut
- Permutationa
- Phi
- Poisson
- Prob
- Standardize
- Tdist
- Tinv
- Ttest
- Weibull
- Ztest
Correlation and line fitting
Ranking
